Обсуждение: Question

Is there a tool to convert    postgresql backups (sql.gz files) to Pgadmin Backups ?

Thank you
-- 

On Thu, Jun 19, 2008 at 8:34 AM, daniel <daniel@ascent-soft.ro> wrote:
> Is there a tool to convert
>    postgresql backups (sql.gz files) to Pgadmin Backups ?

With the exception of PLAIN format dumps, they are entirely compatible
because pgAdmin just calls pg_dump to create them. PLAIN format
backups must be fed into psql however - pg_restore doesn't understand
them, and that's what pgAdmin uses for restores.

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

That's my biggest problem.
The server i have use plain format dumps , but use gz to archive them .

I could change the way backups are made but that's not my goal.

So my problem remains : how can i convert Plain format dumps to files readable by pg_restore ?



Dave Page wrote:

On Thu, Jun 19, 2008 at 8:34 AM, daniel <daniel@ascent-soft.ro> wrote: 

Is there a tool to convert  postgresql backups (sql.gz files) to Pgadmin Backups ?   

With the exception of PLAIN format dumps, they are entirely compatible
because pgAdmin just calls pg_dump to create them. PLAIN format
backups must be fed into psql however - pg_restore doesn't understand
them, and that's what pgAdmin uses for restores.
 

Dascar Daniel
Ascent Soft SRL
www.ascent-soft.ro
daniel@ascent-soft.ro

tel: +40256 40.74.00
fax: +40356 40.90.47
gsm: +40722 32.67.96

On Thu, Jun 19, 2008 at 9:31 AM, daniel <daniel@ascent-soft.ro> wrote:
> That's my biggest problem.
> The server i have use plain format dumps , but use gz to archive them .
>
> I could change the way backups are made but that's not my goal.
>
> So my problem remains : how can i convert Plain format dumps to files
> readable by pg_restore ?

You cannot. You must feed them uncompressed into psql.

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com