[GENERAL] Problem with pg_restore into new database

2008-11-17 Thread Mr. John
Hi. I use latest version of Postgre in windows XP I try to restore a database from .tar backup,into a new database.Using EMS Manager it works fine,my database is creating and restoring succesfully. My application creates a .bat file and run it,restore is unsuccesfully but file is : @echo off

Re: [GENERAL] Problem with pg_restore into new database

2008-11-17 Thread Mr. John
pg_restore: creating PROCEDURAL LANGUAGE plpgsql . From: Richard Huxton [EMAIL PROTECTED] To: Mr. John [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Monday, November 17, 2008 11:31:28 AM Subject: Re: [GENERAL] Problem

Re: [GENERAL] Problem with pg_restore into new database

2008-11-17 Thread Mr. John
and then restore it as in your suggestion no.2 (2. Get pg_restore to create the database for you then switch to it, while connecting with -d to an existing database.) Thanks. From: Richard Huxton [EMAIL PROTECTED] To: Mr. John [EMAIL PROTECTED] Cc: pgsql-general

Re: [GENERAL] Problem with pg_restore into new database

2008-11-17 Thread Mr. John
] To: Mr. John [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Monday, November 17, 2008 1:49:17 PM Subject: Re: [GENERAL] Problem with pg_restore into new database On 17/11/2008 11:26, Mr. John wrote: I read pg_restore documentation and what I understood is that using pg_restore.exe