I dumped a 7.0 db on a RedHat box, createdb'd the db on a new debian box
sporting 7.1, ftp'd the dumped file and restored. Everything seemed to
go fine, except the names of the db and the tables are numeric
expressions instead of the actual table names. For instance, a db named
mydb containing tables table1 and table2 now appears on the new box as
db named 6432466 with tables 6432512 and 6432513. What?? Did I not
install postgresql correctly, miss an environment variable or is this
how the table names are held in the file system on debian boxes? It is
important that I know the file system name for tables as I overwrite
certain tables that are imported from a foxpro table and converted using
dbf2pg. Any guidance here would be greatly appreciated.
Thanks,
Liz