Re: [ADMIN] pg_dumpall doesn't work

[Justin Georgeson]

Justin Georgeson wrote:

Tom Lane wrote:

Justin Georgeson <[EMAIL PROTECTED]> 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'll give that a try.

That worked for the dump, but I still had to enter a password every time the script did a "\connect dbX userY". That was pretty annoying. My pg_hba.conf has two lines

local all trust
host all 127.0.0.1 255.255.255.255 reject

The localhost host reject works. I just added the test if changes were being picked up dynamically, since I was still being prompted for a password. Also, I kept seeing this come up in the output while running the dumpall generated script.

psql:dumpall.sql:40700: ERROR: No such attribute or function 'oid'
CREATE
psql:dumpall.sql:40702: ERROR: No such attribute or function 'oid'
psql:dumpall.sql:40703: ERROR: No such attribute or function 'indislossy'
CREATE
psql:dumpall.sql:40705: ERROR: select rule's target entry 5 has different type from attribute sequence_last_value
psql:dumpall.sql:40706: ERROR: No such attribute or function 'oid'
psql:dumpall.sql:40707: ERROR: No such attribute or function 'oid'

I'm trying to migrate from 7.0.3 to 7.2.1,

*Please* make that 7.2.3 not 7.2.1.

Will look into to that too, especially since postgresql.org has RH RPMs. (I'm a total RH weenie).

rebuilt and installed the SRPMS with little fanfare, no local changes made to the spec files.

--
Justin Georgeson
UnBound Technologies, Inc.
http://www.unboundtech.com
Main 713.329.9330
Fax 713.460.4051
Mobile 512.789.1962

5295 Hollister Road
Houston, TX 77040
Real Applications using Real Wireless Intelligence(tm)


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly