Re: Question

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(at)ascent-soft(dot)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.

--

/*<![CDATA[*/
<!--
@page { size: 8.5in 11in }
P { color: #000000 }
A:link { color: #0000ff }
A:visited { color: #0000ff }
-->
/*]]>*/

Dascar Daniel

Ascent Soft SRL

www.ascent-soft.ro

daniel(at)ascent-soft(dot)ro

tel: +40256 40.74.00

fax: +40356 40.90.47

gsm: +40722 32.67.96