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

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 (view raw or flat)
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



pgsql-interfaces by date

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

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