Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump

pg_dump

From
"stephen`"
Date:

Hi

 

I have a database called eventOrganizer and I am trying to do a backup.

 

When I go pg_dump eventOrganizer;

 

I get this:

 

eventOrganizer=# pg_dump eventOrganizer;

ERROR:  syntax error at or near "pg_dump" at character 1

LINE 1: pg_dump eventOrganizer;

 

Can someone tell me where I am going wrong?

 

Thanks

 

Stephen Choularton

0413 545 182

02 9999 2226

 

 

 

Re: pg_dump

From
"Andrej Ricnik-Bay"
Date:
On 4/26/07, stephen` <mail@xesoftware.com.au> wrote:

> eventOrganizer=# pg_dump eventOrganizer;
>
> ERROR:  syntax error at or near "pg_dump" at character 1
>
> LINE 1: pg_dump eventOrganizer;

> Can someone tell me where I am going wrong?
In trying to run pg_dump from within psql ... you run that
on the command line.


Cheers,
Andrej

Re: pg_dump

From
"Liliana Matos"
Date:
I think that the problem is because you have a capital letter, try put qoutation marks("") or ' ' on eventOrganizer

> eventOrganizer=# pg_dump "eventOrganizer";



On 4/26/07, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote:
On 4/26/07, stephen` <mail@xesoftware.com.au> wrote:

> eventOrganizer=# pg_dump eventOrganizer;
>
> ERROR:  syntax error at or near "pg_dump" at character 1
>
> LINE 1: pg_dump eventOrganizer;

> Can someone tell me where I am going wrong?
In trying to run pg_dump from within psql ... you run that
on the command line.


Cheers,
Andrej

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

pg_dump slave DB

From
"Lukas"
Date:
Hello,

 I am using Postgres 8.1 and slony 1.2.0,

I am trying to dump one of the slave databases, but error:
pg_dump: failed sanity check, parent table OID 3202430 of pg_rewrite entry
OID 17455 not found

stopped me.. what is possible to make in this situation?

thx
Lukas


--
This message has been scanned for viruses and
dangerous content, and is believed to be clean.