| From: | dionysus <dionysus39(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | restoring pgsql database v7.0.3? |
| Date: | 2002-05-24 01:04:26 |
| Message-ID: | 8i2reu8fqdbvhoovv9ndubjts21gda7tfa@4ax.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
My system was broken into, and following the 'if you're paranoid,
you're safe' mentatilty, I reinstalled my OS (Redhat linux 7.1)...I am
now trying to work out how to restore one of my user's databases to
its previous state from an old copy of my /var/lib/pgsql directory
(databases are in /var/lib/pgsql/data/base).....I tried simply
overwriting the fresh install with the files from my backup, but that
somehow corrupted my installation - I had to reinstall the package
(not merely wipe /var/lib/pgsql and re-init the database - which
suggests that part of postgresql containing data about my tables is
contained outside /var/lib/pgsql......wish I'd read up on
postgresql-dump before this....anyhow, if anyone knows how to insert
my old postgresql table files into a fresh postgresql database (I was
thinking of creating the tables with no data in them, the inserting
just the table files, but I didn't write down the field definitions -
i.e. how long the bpchar fields were :-< ), I would much appreciate
any advice....
thanks heaps in advance
-d
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-24 04:27:32 | Re: discovering an index definition |
| Previous Message | Ron Johnson | 2002-05-23 23:58:42 | Re: query problem - get count in related table |