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:snipSorry, I got the sudo command wrong. Confused sudo and su.sudo -u postgres pg_dumpall > /tmp/mypgbackup.sqlcp /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 directoryIs 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.5432See 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.5432That 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.sqlYou will need to provide the Postgres password in this case.Tried this second and the response was:Is the server running on host "localhost"(127.0.0.1) and accepting TCP/IP connections on port 5432?
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!!)!
TIA
Darald
------------------------------------------------------------------------------
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.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel