8/26/2008 7:29 AM
To: Tena Sakai
Cc: Marcelo Martins; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Tena Sakai wrote:
> Hi Alvaro,
>
> I just looked in pg_clog directory and there is
> only one file:
> -rw--- 1 postgres postgres 24576
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Tue 8/26/2008 7:29 AM
To: Tena Sakai
Cc: Marcelo Martins; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Tena Sakai wrote:
> Hi Alvaro,
>
> I just looked in pg_clog
Tena Sakai wrote:
> Hi Alvaro,
>
> I just looked in pg_clog directory and there is
> only one file:
> -rw--- 1 postgres postgres 24576 Aug 25 20:18
> I saw the same file about 10:30 am and I believe
> it was roughly the same size. This is a brand new
> installation of 8.3.3.
Maybe in
]
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Mon 8/25/2008 7:34 PM
To: Tena Sakai
Cc: Marcelo Martins; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Tena Sakai wrote:
> Hi,
>
> I downloaded the latest relea
Tena Sakai wrote:
> Hi,
>
> I downloaded the latest release (8.3.3), followed the
> instruction on the manual to install and restored the
> file I had made by pg_dumpall, thereby bypassing the
> trouble with files in pg_clog directory.
>
> I just read a bit about these files. They are made
> as
: [ADMIN] restoring from dump
I never tried that and I would be reluctant on doing so since you will
be getting status of another transactions.
Marcelo
Linux/Solaris System Administrator
http://www.zeroaccess.org
On Aug 24, 2008, at 4:24 PM, Tena Sakai wrote:
> Hi Marcelo,
>
> > W
PROTECTED]
Sent: Sun 8/24/2008 12:58 PM
To: Tena Sakai
Subject: Re: [ADMIN] restoring from dump
What happened to that clog file ? was it deleted ?
You could try re-creating it with zero contents as a last resort
though .. the transaction will be lost too.
hmm where is 0086, 0087 ?
postgres~$ dd
-Original Message-
From: Marcelo Martins [mailto:[EMAIL PROTECTED]
Sent: Sun 8/24/2008 12:58 PM
To: Tena Sakai
Subject: Re: [ADMIN] restoring from dump
What happened to that clog file ? was it deleted ?
You could try re-creating it with zero contents as a last resort
though .. the tra
t the time very close to
my issuing dropdb.
What are my options now?
Thank you.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Sat 8/23/2008 10:29 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] restoring from dum
e the dropdb command. Of course I'd still recommend you rename
the DB till you're sure the restore was successful.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 10:28 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql
this catch-22 situation?
Any advice appreciated.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 10:28 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Jeff Frost wrote:
> Ten
Jeff Frost wrote:
> Tena Sakai wrote:
>>
>> > If you want to restore all the databases that were in this
>> > postgresql installation at the time of the backup, then the
>> > best thing to do is drop all those DBs before attempting the
>> > restore.
>> Yes, the database in question is built and u
Tena Sakai wrote:
>
> > If you want to restore all the databases that were in this
> > postgresql installation at the time of the backup, then the
> > best thing to do is drop all those DBs before attempting the
> > restore.
> Yes, the database in question is built and updated continuously
> from a
m: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 9:39 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] restoring from dump
On Fri, 22 Aug 2008, Tena Sakai wrote:
> Hi,
>
> I am in a fix...
>
> I have executed the following command being a user postg
e COPY statements you need, then feed those through psql.
I think we need more info about what you're trying to accomplish though.
-Original Message-
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Fri 8/22/2008 3:56 PM
To: Jeff Frost
Cc: pgsql-admin@postgresql.org
Subject:
e a better idea/suggestions?
Please advise.
Thank you.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Fri 8/22/2008 3:56 PM
To: Jeff Frost
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Many tha
: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] restoring from dump
On Fri, 22 Aug 2008, Tena Sakai wrote:
> Many thanks, Jeff.
>
> I am now clued in as to what "postgres" means in the
> context of "psql -f infile postgres". Also, thanks
> for a tip for stdo
Fri 8/22/2008 3:18 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
On Fri, 22 Aug 2008, Tena Sakai wrote:
Hi Everybody,
I had a machine crash a couple of days ago, from which
I have recovered (ie., postgres is running now), but I
want to restore from
uld appreciate
it if you could elucidate.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 3:18 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
On Fri, 22 Aug 2008, Tena Sakai
On Fri, 22 Aug 2008, Tena Sakai wrote:
Hi Everybody,
I had a machine crash a couple of days ago, from which
I have recovered (ie., postgres is running now), but I
want to restore from a dump I had made. The dump is
made by pg_dumpall and I have a gzipped file.
I am a bit unclear as to how to
Hi Everybody,
I had a machine crash a couple of days ago, from which
I have recovered (ie., postgres is running now), but I
want to restore from a dump I had made. The dump is
made by pg_dumpall and I have a gzipped file.
I am a bit unclear as to how to proceed.
(A) I get rid of what I have now
21 matches
Mail list logo
