Thread: problem to connect with postmaster services

problem to connect with postmaster services

From
valcauda Stéphane
Date:
I have installed postgresql 2.95 with cygwin under W2000 without problems.
But since I have reboot to be on my own account ("Stéphane" , with accent).
I can't succeed in lauching postmaster service.
"net start postmaster" give me back an 1069 error , fail to open session.

I can start postgres if I open 2 cygwin session :
One where I launch " /usr/bin/postmaster -D /usr/share/postgresql/data", the
session waiting until I shutdown.

the second one where I launch "psql -U postgres ..."

Is it a good way. Does my error  while launching postmaster service can make
me have problems while using postgresql.

I want to user postgresql with my student, on network to show them
transactions and others functions, does I have to
do something else to work with Postgresql on a network (If I have
understood, I must open a server session with the net start services and the
" /usr/bin/postmaster -D /usr/share/postgresql/data" command.

thanks for help

---------------------------------------------------------
Stéphane Valcauda
Independent Engineer / Teacher in Dijon's University
France




Re: problem to connect with postmaster services

From
Jason Tishler
Date:
Stéphane,

On Tue, Oct 01, 2002 at 12:36:21AM +0200, valcauda Stéphane wrote:
> I have installed postgresql 2.95 with cygwin under W2000 without
> problems.  But since I have reboot to be on my own account ("Stéphane"
> , with accent).  I can't succeed in lauching postmaster service.  "net
> start postmaster" give me back an 1069 error , fail to open session.

The above and the following:

    $ fgrep 1069 /usr/include/w32api/winerror.h
    #define ERROR_SERVICE_LOGON_FAILED 1069L

imply that the user account for postmaster has not been given the "Log
on as a service" right.

Please read the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.2.2.README

> I want to user postgresql with my student, on network to show them
> transactions and others functions, does I have to do something else to
> work with Postgresql on a network (If I have understood, I must open a
> server session with the net start services and the "
> /usr/bin/postmaster -D /usr/share/postgresql/data" command.

Start postmaster which the "-i" option and edit your pg_hba.conf
(if necessary) to enable network access.

Jason