Skip site navigation (1) Skip section navigation (2)

psql var ON_ERROR_ROLLBACK effect in pg_restore

From: Álvaro Guimarães <alvaroguimaraes(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: psql var ON_ERROR_ROLLBACK effect in pg_restore
Date: 2008-05-28 14:42:24
Message-ID: fa5e02ea0805280742i66cccb3ep4393690f3ad83eb0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello list,
I don't found anything about that in the archives, so...
I need to restore an binary backup that is generating errors.
The pg_restore utility is doing a rollback when he found errors.
Can i stop this?
With the psql utility i just set the ON_ERROR_ROLLBACK to get this effect.
Is that possible?
Sorry about my bad english.

-- 
Álvaro Guimarães
Santa Bárbara D'Oeste - SP - Brazil

pgsql-admin by date

Next:From: Karen StoneDate: 2008-05-28 22:55:21
Subject: statistics collector Log message
Previous:From: Scott MarloweDate: 2008-05-27 18:20:27
Subject: Re: Postgres will not shutdown?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group