Re: [SQL] postmaster -i & establishes three connections why?

2003-02-14 Thread Robert Treat
Hi, > > I've just upgraded my cygwin to 1.3.20-1 and postgresql to 7.3.2 > > And I found that when run > > postmaster -i & > > There are three connections being established and why is that? > > Administrator@DemoServer ~ > $ LOG: database system was shut down at 2003-02-13 17:33:26 EST

[SQL] postmaster -i & establishes three connections why?

2003-02-13 Thread Jeff Lu
Hi, I've just upgraded my cygwin to 1.3.20-1 and postgresql to 7.3.2 And I found that when run postmaster -i & There are three connections being established and why is that? Administrator@DemoServer ~ $ LOG: database system was shut down at 2003-02-13 17:33:26 EST LOG: checkpoint record

[SQL] postmaster admin questions

2001-05-10 Thread Markus Wagner
Hi, we are using several Windows-clients to access a pg database on a linux machine. When we want to recreate/change the database "dropdb" says that there still are users connected to it. How can I see which users are connected and how can I disconnect them/ get my db dropped anyway?? Thank yo

[SQL] postmaster not starting on my MS WIN NT

2001-03-20 Thread juerg . rietmann
Hi everybody I found the needed install package for postgres 7.0.3 for win32. Installation worked. When I try to start the postmaster in the cygwin bash shell with postmaster -D /data I get the error as documented in the attached gif. It says something about shared memory problem and semaphore

[SQL] postmaster

2001-01-11 Thread Sharmad Naik
Everytime I have usually start the server manually then runnig the deamons.But sometime (no many times) in 7.0.2 after killing the server with its pid ,The server process doesn't get reinitialized     Has anybody faced this problem?.. What other processes might would be still be running in b

Re: [SQL] postmaster: address already in use

2001-01-03 Thread Tom Lane
Markus Wagner <[EMAIL PROTECTED]> writes: > my postmaster suddenly begins to make problems. It was running fine, but > then: > FATAL: StreamServerPort: bind() failed: Address already in use > Is another postmaster already running on that port? > If not, remove socket node (/tmp/.s.

[SQL] postmaster: address already in use

2001-01-03 Thread Markus Wagner
Hi, my postmaster suddenly begins to make problems. It was running fine, but then: FATAL: StreamServerPort: bind() failed: Address already in use Is another postmaster already running on that port? If not, remove socket node (/tmp/.s.PGSQL.5432) and retry. /sys/svr/pgs/bin/postma

[SQL] postmaster restart error

2000-12-07 Thread rocael
Hi all! I'm using postgresql7.0.2 I did ipcclean and then pg_ctl stop then I tried to start again the DB server as usual nohup postmaster -i > pgserver.log 2>&1 & I got this error: FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2 Startup failed - abort. Somebody know what could be wrong

Re: [SQL] postmaster: init.d/start

2000-06-13 Thread Thomas Mack
>Hi Daniel, > >thank you for your reply. > >There are some unanswered questions. >Why does one have to consider multiple run levels? Doesn't run level 3 >(network + X) implicate run level 2 (network)? Not on SuSE Linux. On SOlaris for example, you will find in /etc/inittab an entry like: s2:23:w

Re: [SQL] postmaster: init.d/start

2000-06-12 Thread Bill Anderson
Markus Wagner wrote: > > Hi Daniel, > > thank you for your reply. > > There are some unanswered questions. > Why does one have to consider multiple run levels? Doesn't run level 3 > (network + X) implicate run level 2 (network)? > So if I don't use XDM (or equivalent) and the system starts with

Re: [SQL] postmaster: init.d/start

2000-06-12 Thread Markus Wagner
Hi Daniel, thank you for your reply. There are some unanswered questions. Why does one have to consider multiple run levels? Doesn't run level 3 (network + X) implicate run level 2 (network)? So if I don't use XDM (or equivalent) and the system starts with a login shell only, it would start run

Re: [SQL] postmaster: init.d/start

2000-06-10 Thread Daniel Fairs
This is the System V-style initialisation. The layout is as follows: /etc/rc.d/init.d/ This directory contains the actual scripts which start and stop the various services on the system. The system supplies a 'start' or 'stop' parameter for the call of the script depending on whether the system

[SQL] postmaster: init.d/start

2000-06-10 Thread Markus Wagner
Hi, under SuSe Linux 6.3 there are different subdirectories rc.d for different runlevels. Each dir contains links to the start/stop scripts. The filenames contain numbers to indicate the position / the order of the services to start. Where (for which runlevel) and at what position should I link