Re: [ADMIN] ODBC connect in ERWin

2001-01-12 Thread Warren Vanichuk
> But When I am trying to forward engineer that to my Remote PostgreSQL db I > am getting ODBC error saying: > 'Could not connect to the Server' > 'Could not connect to remote socket' > > Now, I have already added 'host' line in 'pg_hba.conf' file to give access > to the db from my machine as fol

Re: [ADMIN] Desperately seeking data...

2001-01-12 Thread Ross J. Reedstrom
Ulf - Did you copy the pg_log file? Despite it's name, it's not a just a log: it's used to keep track of the commit state of transactions. Without it, the system will assume than none of your transactions are commited, so will not show you the tuples in those transactions. Ross On Fri, Jan 12,

[ADMIN] How to set checkpoints

2001-01-12 Thread Richard Ray
I've searched the documentation and the mailing lists archive but I'm unable to find info on setting checkpoints and performing roll-forward operations with the transaction log. I'd appreciate it if someone could point me to the right docs. -- Richard Ray Mississippi State Tax Commission [EMAIL P

[ADMIN] Desperately seeking data...

2001-01-12 Thread Ulf Thorsen
After some disc problems we had to copy our database directory to another computer and installed the same version of postgresql (6.5.3-6). The dataTable file, Key file, and the datamodel seems all right when manually inspecting them in an editor. When running psql, we can access the database and