Re: Questions

On Tue, Mar 4, 2014 at 11:49 PM, Chris Travers <..hidden..> wrote:

snip

Sorry, I got the sudo command wrong. Confused sudo and su.

sudo -u postgres pg_dumpall > /tmp/mypgbackup.sql
cp /tmp/mypgbackup /home/myuser/

the response to the sudo . . . is:

pgdumpall: could not connect to database "template1": could not connect to server: No such file or directory

Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

As the system still says that postgres is being halted when there is a system shut down - - - -

Please advise.

When I do a reboot or a halt it does say that postgres 9.3 is being halted in the shutdown sequence so I don't know what's the issue here.

Thanks for the help!!

Darald