v.demartino2@xxxxxxxxxxx wrote:
Context:Postgresql 7.4.6 under linux gentoo
To move a postgres DB from a FreeBSD box to al linux box I pg_dumped the
archive from the FreeBSD box and pg_restored into the linux box: Now when
I pg_dump the archive I get the following warnings for every table in the
archive:
.........................
pg_dump: WARNING: owner of table "atecu91" appears to be invalid
pg_dump: WARNING: owner of table "letture24btdom" appears to be invalid
Who owns tables "atecu91" and "letture24btdom" on the FreeBSD box?
(tip: "\dt atecu91" will show this in psql)
Does this user exist on the Linux box?
("SELECT * FROM pg_user")
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
