Siva Palanisamy wrote:
> However, I get the same list of errors as below. The weird thing is,
it appears to be working fine. I
> could not able to comprehend the error list! I don't have any clue
about it!
>
> For your information, I don't think am running using the superuser
account! But just seem
Siva --
>
> Thanks a lot for your reply. As usual Backup worked perfectly. When I tried
> restore using the command you provided, I got the below list of errors!
> Please help me > out on this.
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error fro
o:amitabhk...@gmail.com]
Sent: Monday, August 08, 2011 2:42 PM
To: Siva Palanisamy
Cc: John R Pierce; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backup & Restore a database in PostgreSQL
Hi Siva
Not sure if it would help, but try passing -O in your pg_restore command.
Amitabh
On Mon, Aug 8, 2
Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: Monday, August 08, 2011 1:45 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Backup & Restore a database in PostgreSQL
&g
stgresql.org] On Behalf Of John R Pierce
Sent: Monday, August 08, 2011 1:45 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backup & Restore a database in PostgreSQL
On 08/08/11 1:01 AM, Siva Palanisamy wrote:
>
> Hi All,
>
> I am also a newbie here! I need to backup a
On 08/08/11 1:01 AM, Siva Palanisamy wrote:
Hi All,
I am also a newbie here! I need to backup a database and restore it
into the target machine where the database may already present or
might not. If it exists, I want the "restore" command to overwrite,
otherwise, just create a new one.
I
Hi All,
I am also a newbie here! I need to backup a database and restore it into the
target machine where the database may already present or might not. If it
exists, I want the "restore" command to overwrite, otherwise, just create a new
one.
I tried using the commands:
(1) BACKUP: pg_dump -h
