retoring a PostgreSQL database from one server to another

[Beau BOB]

Hi,

I have postgresql 7.4.1 and I'm restoring to another server that has postgresql 7.4.6

for dumping I'm using :
pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile

and for restoring I use many methods:
psql -h localhost -U postgres -d template1 -f dbfile

and I have this error message when I run the PgAdminIII to connect my data base:
"error relation pg_settings not found " & " error relation pg_user not found"

and when I use the commands:
psql -l 
ERROR:  relation "pg_catalog.pg_user" not found

notice that when I make restore , I have many error message about missing relation ;

please can anybody help me to resolv my problem
thanks for advance
_________________________________________________________________
Essayez Live.com et créez l'Internet qui vous ressemble : infos, sports, météo et bien plus encore !
http://www.live.com/getstarted

[Martin Marques]

Beau BOB wrote:
> notice that when I make restore , I have many error message about 
> missing relation ;

The question is *which* is the first error?

[Andras Simon]

On 2/28/07, Beau BOB  wrote:
> Hi,
>
> I have postgresql 7.4.1 and I'm restoring to another server that has
> postgresql 7.4.6
>
> for dumping I'm using :
> pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile
>
> and for restoring I use many methods:
> psql -h localhost -U postgres -d template1 -f dbfile
>
> and I have this error message when I run the PgAdminIII to connect my data
> base:
> "error relation pg_settings not found " & " error relation pg_user not
> found"
>
> and when I use the commands:
> psql -l
> ERROR:  relation "pg_catalog.pg_user" not found
>
> notice that when I make restore , I have many error message about missing
> relation ;
>
> please can anybody help me to resolv my problem
> thanks for advance

Are you doing the restore as the postgres user?
Also, it's useful to redirect stderror to a file when doing the
restore, so you can inspect it later.

Andras

[Bruno Wolff III]

On Wed, Feb 28, 2007 at 22:33:10 +0100,
  Andras Simon  wrote:
> On 2/28/07, Beau BOB  wrote:
> > Hi,
> >
> > I have postgresql 7.4.1 and I'm restoring to another server that has
> > postgresql 7.4.6
> >
> > for dumping I'm using :
> > pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile
> >
> > and for restoring I use many methods:
> > psql -h localhost -U postgres -d template1 -f dbfile
>
> Are you doing the restore as the postgres user?

That is what the -U option to psql specifies. So it looks like he is.

[Andras Simon]

On 2/28/07, Bruno Wolff III  wrote:
> On Wed, Feb 28, 2007 at 22:33:10 +0100,
>   Andras Simon  wrote:
> > On 2/28/07, Beau BOB  wrote:
> > > Hi,
> > >
> > > I have postgresql 7.4.1 and I'm restoring to another server that has
> > > postgresql 7.4.6
> > >
> > > for dumping I'm using :
> > > pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile
> > >
> > > and for restoring I use many methods:
> > > psql -h localhost -U postgres -d template1 -f dbfile
> >
> > Are you doing the restore as the postgres user?
>
> That is what the -U option to psql specifies. So it looks like he is.

You're right, sorry for the noise!

Andras

[Martin Marques]

Andras Simon escribió:
> On 2/28/07, Bruno Wolff III  wrote:
> > On Wed, Feb 28, 2007 at 22:33:10 +0100,
> >
> > That is what the -U option to psql specifies. So it looks like he is.
>
> You're right, sorry for the noise!

Beau still has to answer which was the first error psql gave when restoring.

[Bruno Wolff III]

On Wed, Feb 28, 2007 at 15:58:02 +0100,
  Beau BOB  wrote:
> Hi,
>
> I have postgresql 7.4.1 and I'm restoring to another server that has postgresql 7.4.6
>
> for dumping I'm using :
> pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile
>
> and for restoring I use many methods:
> psql -h localhost -U postgres -d template1 -f dbfile
>
> and I have this error message when I run the PgAdminIII to connect my data base:
> "error relation pg_settings not found " & " error relation pg_user not found"
>
> and when I use the commands:
> psql -l 
> ERROR:  relation "pg_catalog.pg_user" not found
>
> notice that when I make restore , I have many error message about missing relation ;
>
> please can anybody help me to resolv my problem
> thanks for advance

There was a very similar question asked on the postgres list asked recently
and the answer was that there was a bug in the selinux definitions for
postgres that break initdb. So you probably need to make sure the destination
system is up to date and redo initdb, then try restoring the database.