I am restoring a database which I rather hastily did not pg_dump, I merely tarred the data files themselves. The data files are too old (8.1) to load into the postgres on the machine I am bringing them to, so I compiled (fc14) and installed postgres 8.1 in order to load them in and pg_dump them, to get a dump file to restore in the new db installation.
Everything was going well until I tried to see the data. That is, I start the postmaster with pg_ctl start -D /mypath/mydata and get 'postmaster starting', the server is running and I can connect to it. It's just that the database I expected to see is not there. Attempting to connect to that database tells me it does not exist.
postgres=# \dn List of schemas Name | Owner --------------------+---------- information_schema | postgres pg_catalog | postgres pg_toast | postgres public | postgres (4 rows) postgres=# \c ridenetdb FATAL: database "ridenetdb" does not exist Previous connection kept
The only thing I touched in the data files was something called pg_hba.conf, I set all connections to 'trust'. Am I just missing something perhaps, or is this a lost cause?