| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | v(dot)demartino2(at)virgilio(dot)it |
| Cc: | postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump warnings |
| Date: | 2005-02-14 11:57:45 |
| Message-ID: | 42109239.3090209@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
v(dot)demartino2(at)virgilio(dot)it 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vittorio De Martino | 2005-02-14 13:17:14 | Re: pg_dump warnings |
| Previous Message | Dave Page | 2005-02-14 11:55:33 | Re: [GENERAL] Website Documentation |