RE: restoring a PostgreSQL database from one server to another

[Beau BOB]

I try this command:  psql -h localhost -U postgres -d template1 -f dbfile 2> errors.log
and I send you the logerror via attachment,
thanks
> Date: Thu, 1 Mar 2007 11:06:11 +0100> From: [e-mail]> To: [e-mail]> Subject: Re: restoring a PostgreSQL database from one server to another> > On 3/1/07, Beau BOB  wrote:> > How I can do the redirect the stderror ? I'm sorry I'm just beginning with> > Postgresql and I don't have experience?!> > Try> > psql -h localhost -U postgres -d template1 -f dbfile 2> errors.log> > (if your shell is bash, or some other sh-derivative; but that's very likely).> Then inspect errors.log.> > Andras> > -- > fedora-list mailing list> [e-mail]> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

_________________________________________________________________
Exprimez-vous : créez la page d'accueil qui vous ressemble avec Live.com.
http://www.live.com/getstarted

restoring a PostgreSQL database from one server to another

[Andras Simon]

On 3/1/07, Beau BOB  wrote:
> I try this command:  psql -h localhost -U postgres -d template1 -f dbfile 2>
> errors.log
> and I send you the logerror via attachment,

Here's what I (not being a postgresql expert) would do:

- Ask for help on a postgresql list ([e-mail] is probably the right forum), with errors.log attached.

- Use the -s switch of pg_dumpall to dump the database schemas only, and try to restore that to see if errors such as the following

psql:dbfile:5416: ERREUR:   the relation «ope_fermer_vue» not found

persist.

- If the previous step succeeds (so I have an empty database with all the tables), I'd look at those extra long lines in dbfile that cause

psql:dbfile:5408: ERREUR:   the Line too large : size 13920, maximum size 8136

Are they there for a good reason? A long line like this is probably one record of a table. I'd certainly look at the definition of that table.

Andras