Changes

Jump to navigation Jump to search
Add to /etc/rc.local
su -c '/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l logfile -D >/usr/local/pgsql/data/serverlog' postgres
Start postgres with one the following commands as the postgres user (if you've fixed the path then abbrev the first part)
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
or(runs the server with output on the terminal) /usr/local/pgsql/bin/pg_ctl postgres -D /usr/local/pgsql/data -l >/usr/local/pgsql/data/logfile start 2>&1 Note that (runs the second command may fail silently if there is something wrong server with output in the config, and logfile - note the first uses path is needed for the terminal unless you add logfile) /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/data/logfile start & (same as above but using the &.pg_ctl wrapper)
Check postgres is listening on 5432:
Anonymous user

Navigation menu