I'm puzzled by a SYSID mismatch I'm seeing on my system. I have a service that fires up PostgreSQL without problems, using pg_ctl via a python script. However, if I execute "pg_ctl start" from a command line I get an error stating that the WAL file SYSID differs from the pg_control SYSID. The service uses my login, so I don't expect permissions are an issue. I've verified that the same data directory is being used in both attempts, but the service succeeds and a manual start fails. Does anyone have a pointer as to what I'm missing?
Windows 7 Pro 64-bit
Thanks very much,
pgsql-novice by date
|Next:||From: Michael Badger||Date: 2012-03-20 22:15:43|
|Subject: Re: ORDER BY with UNION|
|Previous:||From: Sean Davis||Date: 2012-03-20 11:03:13|
|Subject: Re: Optimizing PostgreSQL Queries|