Skip site navigation (1) Skip section navigation (2)

SYSID mismatch

From: Tom Cleaveland <tcleaveland(at)intermapper(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: SYSID mismatch
Date: 2012-03-20 20:54:27
Message-ID: 8C14AED5A219E6488919A8F48192C6CDFA34FD@BY2PRD0510MB352.namprd05.prod.outlook.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

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?

Tech Info:
Windows 7 Pro 64-bit
PostgreSQL 8.3.15

Thanks very much,
Tom


pgsql-novice by date

Next:From: Michael BadgerDate: 2012-03-20 22:15:43
Subject: Re: ORDER BY with UNION
Previous:From: Sean DavisDate: 2012-03-20 11:03:13
Subject: Re: Optimizing PostgreSQL Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group