Well, somebody broke into our server room and stole our server. What
fun.
In any case, I have a backup of our database data (everything in and
under /usr/local/psql/data directory). However, I did not do a
"dump" of the database, which the instructions say I need to do
(followed by a restore) to get the data into a PG 6.4.2 database.
Here is what I need:
Either:
a) an archive of a 6.1 PSQL database that I can install on my system
to get access to the data.
or
b) a way to convert the raw data from a 6.1 database into a format
usable by 6.4.2
I've tried simply installing 6.4.2, overwriting the .../data
directory, and modifying the PG_VERSION files to say 6.4, but I get
the following message when I try to access the DB: "su-2.01$ ./psql billing
Connection to database 'billing' failed.
User authentication failed "
I get the same type of message when I try to run createuser. I've
checked the PG_hba.conf file and it should be allowing access from
the local machine.
I'm about at the limit of my knowledge of what to do here...
Any help greatly appreciated.
Jay W. Summet
