restoring pgsql database v7.0.3?
От | dionysus |
---|---|
Тема | restoring pgsql database v7.0.3? |
Дата | |
Msg-id | 8i2reu8fqdbvhoovv9ndubjts21gda7tfa@4ax.com обсуждение исходный текст |
Ответы |
Re: restoring pgsql database v7.0.3?
|
Список | 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
В списке pgsql-novice по дате отправления: