[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Questions

On Wed, Mar 5, 2014 at 6:09 AM, o1bigtenor <..hidden..> wrote:

I counted  - - - I have over 12 pages of commands (written out) that I have worked through in this odyssey to date!

On Wed, Mar 5, 2014 at 7:47 AM, Chris Travers <..hidden..> wrote:


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"?

ok then.  As root try:

locate .s.PGSQL.5432

See if that shows anything.  If not, of if you get an error you may need to:

Tried this first and no joy!

find / -name  .s.PGSQL.5432

That may take a while though.

As the third option ran and provided nothing - - - bummer!

As an alternative you could just do as follows instead:

pg_dumpall -h localhost -u postgres > /home/myuser/mydbdump.sql

You will need to provide the Postgres password in this case.

Tried this second and the response was:

Is the server running on host "localhost"( and accepting TCP/IP connections on port 5432?

Maybe PostgreSQL isn't running after all.


 ps -A | grep postgres

If that returns nothing then PostgreSQL isn't running afterall.

As I am NOT able to run firefox etal at this time (no working X system) that sort of made sense after I read it.

I am starting to see why companies just off load this to an IT person (and pity that poor sucker!!)!



Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
Ledger-smb-devel mailing list

Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.