3 ms·

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

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
    - simoncion 11y ago
      > ...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!! Well, because you have access to the file that causes Postgres to determine whether or not you need to provide a password to access a given database (pg_hba.conf), you could simply change the authentication method to one that doesn't ask for a password. :) However. On every Postgres install I've ever used, there are the following lines in pg_hba.conf: # "local" is for Unix domain socket connections only local all all trust If we look carefully, we see that the Type, Database, User, and Method entries are present, but the Address entry is not. The comment also talks about a Unix domain socket connection. Reading the "Connecting to a Database" section of the manual for psql [0] (the official command-line Postgres client) tells us that if we omit the hostname, psql attempts to connect over the Unix domain socket. So, try the following things: * psql When that fails, because 'role "$MY_USERNAME" does not exist', try * psql -U $DATABASE_USER (The Postgresql database user is typically postgres.) If that fails for some other reason, try * sudo su - $DATABASE_USER * psql You should now be connected to Postgres. If we enter help , we see that we can enter "\?" for help with psql commands. If we enter \? and look through the list of commands, we should see one that does exactly the thing that we're trying to accomplish. Anyway, leave a message here to let me know how this all went, or to ask any follow up questions. [0] http://www.postgresql.org/docs/9.4/static/app-psql.html http://www.postgresql.org/docs/9.4/static/app-psql.html
      - thewhitetulip 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
  - simoncion 11y ago
    > ...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!! Well, because you have access to the file that causes Postgres to determine whether or not you need to provide a password to access a given database (pg_hba.conf), you could simply change the authentication method to one that doesn't ask for a password. :) However. On every Postgres install I've ever used, there are the following lines in pg_hba.conf: # "local" is for Unix domain socket connections only local all all trust If we look carefully, we see that the Type, Database, User, and Method entries are present, but the Address entry is not. The comment also talks about a Unix domain socket connection. Reading the "Connecting to a Database" section of the manual for psql [0] (the official command-line Postgres client) tells us that if we omit the hostname, psql attempts to connect over the Unix domain socket. So, try the following things: * psql When that fails, because 'role "$MY_USERNAME" does not exist', try * psql -U $DATABASE_USER (The Postgresql database user is typically postgres.) If that fails for some other reason, try * sudo su - $DATABASE_USER * psql You should now be connected to Postgres. If we enter help , we see that we can enter "\?" for help with psql commands. If we enter \? and look through the list of commands, we should see one that does exactly the thing that we're trying to accomplish. Anyway, leave a message here to let me know how this all went, or to ask any follow up questions. [0] http://www.postgresql.org/docs/9.4/static/app-psql.html http://www.postgresql.org/docs/9.4/static/app-psql.html
    - thewhitetulip 11y ago