Обсуждение: PostgreSQL on Windows
I am running 8.4 on a Windows Vista system. The software was installed using the auto-install process. PostgreSQL starts successfully as a service when the system boots. The running postgres* processes can be verified via Task Manager. I can run psql from the command prompt. I have the PGDATA env variable set to the folder where the PostgreSQL data sits. Running the pg_ctl status command from the command prompt returns "pg_ctl: no server running". Ideas why pg_ctl doesn't know about the running services?
Mark
Mark
On 29/03/2010 18:38, Mark Vantzelfde wrote: > I am running 8.4 on a Windows Vista system. The software was installed using > the auto-install process. PostgreSQL starts successfully as a service when > the system boots. The running postgres* processes can be verified via Task > Manager. I can run psql from the command prompt. I have the PGDATA env > variable set to the folder where the PostgreSQL data sits. Running the > pg_ctl status command from the command prompt returns "pg_ctl: no server > running". Ideas why pg_ctl doesn't know about the running services? Have you tried running it with the -D option instead of the env variable? No idea if it will make any difference...just a wild guess. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Same result.
--
Mark Vantzelfde
NetMasters, Inc.
On Mon, Mar 29, 2010 at 1:51 PM, Raymond O'Donnell <rod@iol.ie> wrote:
Have you tried running it with the -D option instead of the envOn 29/03/2010 18:38, Mark Vantzelfde wrote:
> I am running 8.4 on a Windows Vista system. The software was installed using
> the auto-install process. PostgreSQL starts successfully as a service when
> the system boots. The running postgres* processes can be verified via Task
> Manager. I can run psql from the command prompt. I have the PGDATA env
> variable set to the folder where the PostgreSQL data sits. Running the
> pg_ctl status command from the command prompt returns "pg_ctl: no server
> running". Ideas why pg_ctl doesn't know about the running services?
variable? No idea if it will make any difference...just a wild guess.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
--
Mark Vantzelfde
NetMasters, Inc.
Could it be that pg_ctl uses some sort of unix cmd like ps to try to determine with the postgres processes are running? Using ps from a windows command prompt does not show the postgres processes started as services.
Mark
--
Mark Vantzelfde
NetMasters, Inc.
Mark
On Mon, Mar 29, 2010 at 1:54 PM, Mark Vantzelfde <netmasters.ma@gmail.com> wrote:
Same result.--On Mon, Mar 29, 2010 at 1:51 PM, Raymond O'Donnell <rod@iol.ie> wrote:Have you tried running it with the -D option instead of the envOn 29/03/2010 18:38, Mark Vantzelfde wrote:
> I am running 8.4 on a Windows Vista system. The software was installed using
> the auto-install process. PostgreSQL starts successfully as a service when
> the system boots. The running postgres* processes can be verified via Task
> Manager. I can run psql from the command prompt. I have the PGDATA env
> variable set to the folder where the PostgreSQL data sits. Running the
> pg_ctl status command from the command prompt returns "pg_ctl: no server
> running". Ideas why pg_ctl doesn't know about the running services?
variable? No idea if it will make any difference...just a wild guess.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
Mark Vantzelfde
NetMasters, Inc.
--
Mark Vantzelfde
NetMasters, Inc.