Skip site navigation (1) Skip section navigation (2)

Re: pg_dumpall doesn't work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Georgeson <jgeorgeson(at)unboundtech(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall doesn't work
Date: 2002-12-13 20:43:49
Message-ID: 28985.1039812229@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Justin Georgeson <jgeorgeson(at)unboundtech(dot)com> writes:
> This is what I get when I do a pg_dumpall. I have *no* idea what to do 
> here.

It's a lot easier to do pg_dumpall if you are not using password
authentication.  Consider downgrading your pg_hba setting to "trust" for
local connections while you do the dump.  (In 7.2 you could perhaps use
ident, or at least secure the socket with filesystem access restrictions.)

> I'm trying to migrate from 7.0.3 to 7.2.1,

*Please* make that 7.2.3 not 7.2.1.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Justin GeorgesonDate: 2002-12-13 20:57:38
Subject: Re: pg_dumpall doesn't work
Previous:From: Justin GeorgesonDate: 2002-12-13 20:03:18
Subject: pg_dumpall doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group