5 ms·

I have read so much about postgres as a database, but sadly I have never been able to actually download install and use it, have read many tutorials but unfortu

I have read so much about postgres as a database, but sadly I have never been able to actually download install and use it, have read many tutorials but unfortunately it isn't as simple as installing mysql

Illniyar 11y ago
Windows has an msi that also installs pgadmin and sets it up as a service, nothing could be simpler
stadeschuldt 11y ago
What is your system? Installing it on OSX is super easy. Either using Homebrew or http://postgresapp.com http://postgresapp.com
- thewhitetulip 11y ago
  Elementary OS
jimktrains2 11y ago
It is as simple, it's just not the same. It's also in most distro and bsd repos. For the benefits of PostgreSQL over MySQL it is definitely worth learning.
jaddison 11y ago
I can only assume that you are not using any mainstream *nix-based operating system. Installing through package management is easy for both MySQL and PostgreSQL.
- TylerE 11y ago
  There are easy one-or-two-click installers for Windows and Mac OS X as well.
- thewhitetulip 11y ago
  I am using elementary OS and I have installed it many times, can you give me a good tutorial about installing and configuring postgres? I want to use it with golang for development of webapps. I am not trolling here btw, I am really stuck with sqlite because of inability of installing postgrest :(
  - simoncion 11y ago
    I mean, with Gentoo Linux I had to do the following things: * If I wanted to make Postgres listen on non-localhost, modify listen_addresses in postgresql.conf. * Add database access controls as required in pg_hba.conf. The comments in the file are illuminating, but one can examine [0] for more information. [1] * Create a database with appropriate permissions, along with a user. [2] * Start Postgres. I remember having to do the equivalent of all of those things every time I had to install MySQL. :) What -exactly- did you successfully do, what -exactly- did you fail to do? Divulging that information will help guide assistance efforts. :) [0] http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.h... [1] For example, the following line would allow password-based access from IPv4 localhost by the user "user" to the database "database": host database user 127.0.0.1/32 md5 [2] http://www.postgresql.org/docs/9.4/static/sql-createdatabase.html http://www.postgresql.org/docs/9.4/static/sql-createdatabase... for CREATE DATABASE syntax (or you can use createdb http://www.postgresql.org/docs/9.4/static/app-createdb.html http://www.postgresql.org/docs/9.4/static/app-createdb.html ) http://www.postgresql.org/docs/9.4/static/sql-createrole.html http://www.postgresql.org/docs/9.4/static/sql-createrole.htm... for CREATE ROLE syntax (or you can use http://www.postgresql.org/docs/9.4/static/app-createuser.html http://www.postgresql.org/docs/9.4/static/app-createuser.htm... ) http://www.postgresql.org/docs/9.4/static/sql-grant.html http://www.postgresql.org/docs/9.4/static/sql-grant.html for GRANT syntax.
    - thewhitetulip 11y ago
      Hey, I use elementary OS and all I did was sudo apt-get install postgres I have no idea what it installed and what it didn't, in the entire process never once it asked me for a password and while connecting to the database it says that invalid password and I can't reset password without connecting to the database!! May I know your email ID? so I'll try to install it once and tell you how it goes. As of now I have everything installed plus the graphical client with the elephant logo, but I just have no idea what the password is
Kinnard 11y ago
Have you asked a friend for help?
- saurik 11y ago
  They already used "phone a friend" when they installed Python, so this time they are trying "ask the audience"; I can't wait to see them try and use "50/50" to install nginx.
aembleton 11y ago
Try running it inside docker: https://hub.docker.com/_/postgres/ https://hub.docker.com/_/postgres/ I find that to be the easiest way to get up and running with it.
jakobegger 11y ago
I'd love to hear what issues you're facing (if you can remember any specifics). Its been a long time since I first installed PostgreSQL, but I also recall some difficulties. Some things have improved since (eg. it's no longer necessary to change shared memory kernel parameters) but some things are still pretty difficult (eg. correctly configuring pg_hba.conf). Other things are just confusing to newcomers (eg. different meanings of the term "database" between MySQL and Postgres, or understanding schemas and search_path).
- thewhitetulip 11y ago
  Hey, I installed it via the available things on ubuntu software center, I have the graphical utility installed but when I try to connect to it, it says invalid password and I have no idea what the default password is since it didnt ask me
  - jimktrains2 11y ago
    Have you created a user? If you don't create a user, and aren't acting as the postgres user, how do you expect to connect?
    - thewhitetulip 11y ago
      Sadly though I have no idea how to do that, can you direct me to some easy to understand installation guide?
MagicWishMonkey 11y ago
Really? On OSX it's as simple as downloading postgres.app and dropping it in your applications folder. Couldn't be easier.
- thewhitetulip 11y ago
  I don't use OSX I use elementary OS and I installed everything but it says incorrect password and I have no damn clue what the default password is because while installation it didn't ask me for a password!
  - jimktrains2 11y ago
    What documentation or tutorial were you following? The first thing you need to do is create a user (or act as the postgres user on your os) and if the doc or tutorial was an official one, it should be made more clear and you should file a bug, if it wasn't then you should contact the owner and tell them their tutorial isn't clear.
    - thewhitetulip 11y ago
      https://help.ubuntu.com/community/PostgreSQL https://help.ubuntu.com/community/PostgreSQL I got all the help from this thread and the above link!
chungy 11y ago
It's easy on any major OS. Windows and OS X have one/two-click installers, Linux distros and BSDs pre-package it. The only really difficult case is a less-mainstream OS where you'll have to compile it, which honestly isn't that hard either.

Illniyar 11y ago

Windows has an msi that also installs pgadmin and sets it up as a service, nothing could be simpler

stadeschuldt 11y ago

What is your system? Installing it on OSX is super easy. Either using Homebrew or http://postgresapp.com http://postgresapp.com

thewhitetulip 11y ago
Elementary OS

jimktrains2 11y ago

It is as simple, it's just not the same. It's also in most distro and bsd repos. For the benefits of PostgreSQL over MySQL it is definitely worth learning.

jaddison 11y ago

I can only assume that you are not using any mainstream *nix-based operating system. Installing through package management is easy for both MySQL and PostgreSQL.

TylerE 11y ago
There are easy one-or-two-click installers for Windows and Mac OS X as well.
thewhitetulip 11y ago
I am using elementary OS and I have installed it many times, can you give me a good tutorial about installing and configuring postgres? I want to use it with golang for development of webapps. I am not trolling here btw, I am really stuck with sqlite because of inability of installing postgrest :(
- simoncion 11y ago
  I mean, with Gentoo Linux I had to do the following things: * If I wanted to make Postgres listen on non-localhost, modify listen_addresses in postgresql.conf. * Add database access controls as required in pg_hba.conf. The comments in the file are illuminating, but one can examine [0] for more information. [1] * Create a database with appropriate permissions, along with a user. [2] * Start Postgres. I remember having to do the equivalent of all of those things every time I had to install MySQL. :) What -exactly- did you successfully do, what -exactly- did you fail to do? Divulging that information will help guide assistance efforts. :) [0] http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.h... [1] For example, the following line would allow password-based access from IPv4 localhost by the user "user" to the database "database": host database user 127.0.0.1/32 md5 [2] http://www.postgresql.org/docs/9.4/static/sql-createdatabase.html http://www.postgresql.org/docs/9.4/static/sql-createdatabase... for CREATE DATABASE syntax (or you can use createdb http://www.postgresql.org/docs/9.4/static/app-createdb.html http://www.postgresql.org/docs/9.4/static/app-createdb.html ) http://www.postgresql.org/docs/9.4/static/sql-createrole.html http://www.postgresql.org/docs/9.4/static/sql-createrole.htm... for CREATE ROLE syntax (or you can use http://www.postgresql.org/docs/9.4/static/app-createuser.html http://www.postgresql.org/docs/9.4/static/app-createuser.htm... ) http://www.postgresql.org/docs/9.4/static/sql-grant.html http://www.postgresql.org/docs/9.4/static/sql-grant.html for GRANT syntax.
  - thewhitetulip 11y ago
    Hey, I use elementary OS and all I did was sudo apt-get install postgres I have no idea what it installed and what it didn't, in the entire process never once it asked me for a password and while connecting to the database it says that invalid password and I can't reset password without connecting to the database!! May I know your email ID? so I'll try to install it once and tell you how it goes. As of now I have everything installed plus the graphical client with the elephant logo, but I just have no idea what the password is

Kinnard 11y ago

Have you asked a friend for help?

saurik 11y ago
They already used "phone a friend" when they installed Python, so this time they are trying "ask the audience"; I can't wait to see them try and use "50/50" to install nginx.

aembleton 11y ago

Try running it inside docker: https://hub.docker.com/_/postgres/ https://hub.docker.com/_/postgres/ I find that to be the easiest way to get up and running with it.

jakobegger 11y ago

I'd love to hear what issues you're facing (if you can remember any specifics). Its been a long time since I first installed PostgreSQL, but I also recall some difficulties. Some things have improved since (eg. it's no longer necessary to change shared memory kernel parameters) but some things are still pretty difficult (eg. correctly configuring pg_hba.conf). Other things are just confusing to newcomers (eg. different meanings of the term "database" between MySQL and Postgres, or understanding schemas and search_path).

thewhitetulip 11y ago
Hey, I installed it via the available things on ubuntu software center, I have the graphical utility installed but when I try to connect to it, it says invalid password and I have no idea what the default password is since it didnt ask me
- jimktrains2 11y ago
  Have you created a user? If you don't create a user, and aren't acting as the postgres user, how do you expect to connect?
  - thewhitetulip 11y ago
    Sadly though I have no idea how to do that, can you direct me to some easy to understand installation guide?

MagicWishMonkey 11y ago

Really? On OSX it's as simple as downloading postgres.app and dropping it in your applications folder. Couldn't be easier.

thewhitetulip 11y ago
I don't use OSX I use elementary OS and I installed everything but it says incorrect password and I have no damn clue what the default password is because while installation it didn't ask me for a password!
- jimktrains2 11y ago
  What documentation or tutorial were you following? The first thing you need to do is create a user (or act as the postgres user on your os) and if the doc or tutorial was an official one, it should be made more clear and you should file a bug, if it wasn't then you should contact the owner and tell them their tutorial isn't clear.
  - thewhitetulip 11y ago
    https://help.ubuntu.com/community/PostgreSQL https://help.ubuntu.com/community/PostgreSQL I got all the help from this thread and the above link!

chungy 11y ago

It's easy on any major OS. Windows and OS X have one/two-click installers, Linux distros and BSDs pre-package it. The only really difficult case is a less-mainstream OS where you'll have to compile it, which honestly isn't that hard either.