We backed up our test server yesterday (Pg 7.4.1) as the first step in switching from Red Hat 7 to Whitebox. However, we failed to back up the transaction and commit logs. Now that the OS and database are back to where they were, we get this message on attempting to restart:
LOG: could not open file "/usr/local/pgsql/data/pg_xlog/00000041000000EE" (log file 65, segment 238): No such file or directory (There are other problems that we are still working to correct, but this is the one that I don't understand.) -- ~~~~~~~~~~~~~~~~| Genius may have its limitations, but stupidity is not Jeff Boes | thus handicapped. [EMAIL PROTECTED] | --Elbert Hubbard (1856-1915), American author ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match