I cant seem to get pg_restore to work for me.
here's how im calling it:
pg_restore -d -C -v -U
It keeps on telling me that the database does not exist so it
cant connect to it. I thought the -C flag creates the database, what am
i missing here?
Thanks
Alex
---(end of
I am working with postgres 8.0.3 on suse linux 9.3.I want to restore data
from pg_dump backup.Previously it was working fine with the same dump.
But now it is giving the following error...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"sw_4904.operatorjob" does not exist
I am having problems with pg_restore. pg_restore
--file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
--username=postgres
this just hangs.
I am restoring from 8.3.7 to 8.4 - what did I do wrong?
could somebody rewrite pg_dumpall and pg_dump so that it makes editable dumps
Alexander Cohen <[EMAIL PROTECTED]> writes:
> pg_restore -d -C -v -U
> It keeps on telling me that the database does not exist so it
> cant connect to it. I thought the -C flag creates the database, what am
> i missing here?
It does, but you have to connect somewhere first so you can issue
On Tue, Jul 14, 2009 at 7:47 PM, Jim Michaels wrote:
> could somebody rewrite pg_dumpall and pg_dump so that it makes editable
> dumps?
> most programmer's text editors can't handle more than 2000 characters per
> line.
> and I want to be able to edit my dumps.
You're going to have better luck fin
Jim Michaels wrote:
I am having problems with pg_restore. pg_restore
--file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
--username=postgres
this just hangs.
I am restoring from 8.3.7 to 8.4 - what did I do wrong?
Well, I don't see a database name, was that just an ac
Jim Michaels, 15.07.2009 01:47:
most programmer's text editors can't handle more than 2000 characters
per line.
and I want to be able to edit my dumps.
I don't know what you are using, but the following editors can certainly handle
more than 2000 characters:
OpenSource and free:
http://www.p
On 2009-07-14, Jim Michaels wrote:
>
> --0-1060148048-1247615236=:84835
> Content-Type: text/plain; charset=us-ascii
>
> I am having problems with pg_restore. pg_restore
> --file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
> --username=postgres
>
> this just hangs.
> I a
On Thu, Jul 23, 2009 at 10:47:40AM +, Jasen Betts wrote:
> I find that jed is powerful, fast, and reasonably easy to use. and had
> no problem with 2.3MB lines.
>
> gnome-text-editor ("gedit") handles lines of tens of thousands of
> characters OK but seems to have problems displaying million
On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels wrote:
> I am having problems with pg_restore. pg_restore
> --file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
> --username=postgres
>
> this just hangs.
> I am restoring from 8.3.7 to 8.4 - what did I do wrong?
>
> could somebo
On Thu, Jul 23, 2009 at 07:40:18AM -0600, Scott Marlowe wrote:
> On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels wrote:
> > could somebody rewrite pg_dumpall and pg_dump so that it makes editable
> > dumps?
> > most programmer's text editors can't handle more than 2000
> > characters per line. and I
On Thu, Jul 23, 2009 at 3:14 PM, Sam Mason wrote:
> On Thu, Jul 23, 2009 at 07:40:18AM -0600, Scott Marlowe wrote:
>> On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels wrote:
>> > could somebody rewrite pg_dumpall and pg_dump so that it makes editable
>> > dumps?
>> > most programmer's text editors can
Hi, I'm a Postgis user, and I have a problem
restoring data from 7.4 to 8.0.0beta2.
I use the postgis_restore.pl script that comes with
postgis distribution.
I do the following for the dump:
pg_dump -Fc mydb
>mydb.sql
and the script does the following restore
operations:
... some c
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
Hello,
I have an problem with using pg_restore in windows VISTA. I created the
pgpass.conf file and copied it into the APPDATA of user currently logged in.
The pgpass.conf file has all the rights of postgres service account.
Well its perfectly working on Windows XP but when i try it on VISTA it g
Mr. John wrote:
> but on the server is no database called _struct_fis_
> err_resto.txt file contents only "0".
>
> If I add -d
> @echo off
> "pg_restore.exe" -h 192.168.1.1 -p 5432 -U postgres -d "_struct_fis_" -C -v
> "stru.tar" 2>>log_resto.txt
> echo %errorlevel% >err_resto.txt
>
>
November 17, 2008 11:31:28 AM
Subject: Re: [GENERAL] Problem with pg_restore into new database
Mr. John wrote:
> but on the server is no database called _struct_fis_
> err_resto.txt file contents only "0".
>
> If I add -d
> @echo off
> "pg_restore.exe" -h
Mr. John wrote:
> tanks for reply.
>
> Why should I connect to a existing database to restore another one ?
How do you issue a "CREATE DATABASE" command without being connected to
something?
> from documentation,pg_restore seems to can do this :
> http://www.postgresql.org/docs/8.0/interactive/a
IL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent: Monday, November 17, 2008 12:08:00 PM
Subject: Re: [GENERAL] Problem with pg_restore into new database
Mr. John wrote:
> tanks for reply.
>
> Why should I connect to a existing database to restore another one ?
How do you issue a &qu
On 17/11/2008 11:26, Mr. John wrote:
> I read pg_restore documentation and what I understood is that using
> pg_restore.exe with -C will create the database named in backup archive
> or specified with -d
You have to connect to *some* database, as Postgres doesn't have the
concept of just connec
___
From: Raymond O'Donnell <[EMAIL PROTECTED]>
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
21 matches
Mail list logo