Re: [HACKERS] How can I recovery old Data from files and
I already reinstall old version of PostgreSQL. However I still cannot run PostgreSQL service after I reinstall on many time. I think that I cannot use pg_dump or all command without PostgreSQL service running. So What thing I can do now? Andrew Dunstan [EMAIL PROTECTED] 7/12/2004 10:18:19 pm Premsun Choltanwanich wrote: I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of it back it will be make a same error. I just want to restore only DATA (databases, functions, views, users, group etc). Please suggest me that How can I recovery old Data from files and folders on windows? PostgreSQL does not work like that. You should have backed up using pg_dump before uninstalling. File system backup won't work across catalog versions. In fact, your best bet is probably to reinstall the old version so you can start the server and run pg_dump. cheers andrew ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] How can I recovery old Data from files and folders on windows?
I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of it back it will be make a same error. I just want to restore only DATA (databases, functions, views, users, group etc). Please suggest me that How can I recovery old Data from files and folders on windows? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] How can I recovery old Data from files and folders
Premsun Choltanwanich wrote: I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of it back it will be make a same error. I just want to restore only DATA (databases, functions, views, users, group etc). Please suggest me that How can I recovery old Data from files and folders on windows? PostgreSQL does not work like that. You should have backed up using pg_dump before uninstalling. File system backup won't work across catalog versions. In fact, your best bet is probably to reinstall the old version so you can start the server and run pg_dump. cheers andrew ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])