| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tulio Oliveira <mestredosmagos(at)marilia(dot)com> |
| Cc: | Tulio Oliveira <tulio(at)marilia(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I lost the pg_control file |
| Date: | 2001-05-07 00:06:45 |
| Message-ID: | 6800.989194005@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tulio Oliveira <mestredosmagos(at)marilia(dot)com> writes:
> Yeah, I run configure by myself... But I download the lastest PostgreSQL
> version 7.1.1 and with this I can compile the pg_resetxlog... Then I ran
> it over my $PGDATA directory with 4.5Gb of data.
> But then, all data lost. When I "psql dbtest" and type \d, I can't see
> any tables in there...
Hm. Try tweaking pg_resetxlog to insert a really large "next
transaction number" in the -f case, say about 2 billion instead of the
rather silly 514 it's using now (there are two places to change, look
for XXX comments).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alfred Perlstein | 2001-05-07 00:48:19 | Re: Dead locks |
| Previous Message | Aristide Aragon | 2001-05-06 23:19:06 | Dead locks |