From: sasha <sasha(at)pl(dot)avalbank(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject:
Date: 2001-03-31 04:45:23
Message-ID: 12364.010331@pl.avalbank.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello pgsql-interfaces,

sasha(at)SAN /usr/local/pgsql/bin
$ ./pg_ctl -D /usr/local/pgsql/datapage start
postmaster successfully started up.

sasha(at)SAN /usr/local/pgsql/bin
$ DEBUG: Data Base System is starting up at Fri Mar 30 21:50:55 2001
DEBUG: Data Base System was shut down at Fri Mar 30 21:02:48 2001
DEBUG: Data Base System is in production state at Fri Mar 30 21:50:55 2001

sasha(at)SAN /usr/local/pgsql/bin
$ ./createdb test
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
createdb: database creation failed

sasha(at)SAN /usr/local/pgsql/bin
$ ./postmaster status
IpcMemoryCreate: shmget failed (Identifier removed) key=5432007, size=66060, per
mission=600
SISegmentInit: segment create failed: Identifier removed
FATAL 1: CreateSharedInvalidationState: failed segment init
NOTICE: IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE: IpcMemoryDetach: shmdt(0x???????): Invalid argument

sasha(at)SAN /usr/local/pgsql/bin
$ ./postmaster stop
IpcMemoryCreate: shmget failed (Identifier removed) key=5432010, size=144, permi
ssion=700
IpcMemoryIdGet: shmget failed (Identifier removed) key=5432010, size=144, permis
sion=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment

sasha(at)SAN /usr/local/pgsql/bin
$ ps
PID PPID PGID WINPID TTY UID STIME COMMAND
1076 1 1076 1076 0 1000 21:43:24 /usr/bin/bash
1064 1076 1064 1032 0 1000 21:43:35 /usr/local/bin/ipc-daemon
572 1 1000 572 0 1000 21:50:53 /usr/bin/sh
1092 572 1000 656 0 1000 21:50:53 /usr/local/pgsql/bin/postgres
856 1076 856 536 0 1000 22:03:50 /usr/bin/ps

sasha(at)SAN /usr/local/pgsql/bin
$ kill 1092

sasha(at)SAN /usr/local/pgsql/bin
Smart Shutdown request at Fri Mar 30 22:03:56 2001
$ DEBUG: Data Base System shutting down at Fri Mar 30 22:03:57 2001
DEBUG: Data Base System shut down at Fri Mar 30 22:03:57 2001
NOTICE: IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE: IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE: IpcMemoryDetach: shmdt(0x???????): Invalid argument

--
Best regards,
sasha mailto:sasha(at)pl(dot)avalbank(dot)com

Browse pgsql-interfaces by date

  From Date Subject
Next Message darius 2001-04-01 01:21:25 postgresql array with PHP
Previous Message The Hermit Hacker 2001-03-30 21:48:47 Re: [HACKERS] Re: [ADMIN] User administration tool