Post PostgreSQL Installation

After installation of PostgreSQL start PostgreSQL by executing the command to see if the installation worked.

/etc/init.d/postgresql start

In the file ‘/var/lib/pgsql/data/pg_hba.conf’, replace all entries of “ident sameuser” with “trust”.

In the file ‘/var/lib/pgsql/data/postgresql.conf’, change the line “max_connections=100″ to max_connections=500″.

Restart PostgreSQL.

/etc/init.d/postgresql stop
/etc/init.d/postgresql start

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.