postgresql backup and restore needed, for a postgres 8.4 server on CentOPS
Must be familiar with pg_dump and pg_dumpall
The backup should be 3 files, one of those a tar with multiple files.
1. [login to view URL] - with the grants for a particular user
2. cat [login to view URL] - with the postgresql users and encrypted password
3. a tar file, one for each database - the tar should contain #.dat files, a [login to view URL] file, and a [login to view URL] file, to create the tables and import the data.
I will provide a sample backup to work with.