postgres crash
I work with Postgres Win 2000 using Cygwin
template1=# select version();
version
------------------------------------------------------------
PostgreSQL 7.2 on i686-pc-cygwin, compiled by GCC 2.95.3-5
Sometime, the database crashes and I receive the folllwing log message:
DEBUG: recycled transaction log file 000000000000008B
FATAL 2: link from /usr/share/postgresql/data/pg_xlog/000000000000008B to /usr/
share/postgresql/data/pg_xlog/0000000000000093 (initialization of log file 0, se
gment 147) failed: Permission denied
DEBUG: server process (pid 1408) exited with exit code 2
DEBUG: terminating any other active server processes
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and a
m
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
DEBUG: all server processes terminated; reinitializ
ing shar
e
d memory and semaph
ores
IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough mem
ory
This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 1441792 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).
The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.
I changed the shared_buffers and max_connections parameters, but the problem is not solved.
It is possible that my configuration is wrong ?
Thank you
Bye !!
Frank Lupo (Wolf) !!
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Per tanti sonni felici, fai un fantastcio regalo al tuo bambino l'Autoletto
come una vera auto sportiva. Lo trovi solo nel MammaShop.it
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=625&d=13-9
On Fri, 13 Sep 2002 18:13:43 +0200, "frank_lupo" <frank_lupo@email.it>
wrote:
DEBUG: recycled transaction log file 000000000000008B
FATAL 2: link from /usr/share/postgresql/data/pg_xlog/000000000000008B to /usr/
share/postgresql/data/pg_xlog/0000000000000093 (initialization of log file 0, se
gment 147) failed: Permission denied
^^^^^^^^^^^^^^^^^
Frank, this seems to be is the relevant part.
Which user is running postmaster, and to whom does the directory
/usr/share/postgresql/data/pg_xlog belong?
Servus
Manfred
On Fri, 13 Sep 2002 18:13:43 +0200, "frank_lupo"
wrote:DEBUG: recycled transaction log file 000000000000008B
FATAL 2: link from /usr/share/postgresql/data/pg_xlog/000000000000008B to /usr/
share/postgresql/data/pg_xlog/0000000000000093 (initialization of log file 0, se
gment 147) failed: Permission denied^^^^^^^^^^^^^^^^^
Frank, this seems to be is the relevant part.Which user is running postmaster, and to whom does the directory
/usr/share/postgresql/data/pg_xlog belong?Servus
Manfred
I use cygwin for win2000. For star postmaster using service nt.
The service is installed using the following definition:
cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shut
Postmaster running by postgres user.=0
D
0
AAdministrator@pippo /usr/share/postgresql/data/pg_xlog
$ ll
total 114688
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 17:36 000000000000008D
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 4 14:16 000000000000008E
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 4 16:40 000000000000008F
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 5 09:40 0000000000000090
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 11 10:35 0000000000000091
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 10:07 0000000000000092
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 15:56 0000000000000093
Bye !!
Frank Lupo (Wolf) !!
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Baby Zen riproduce i suoni della natura. Ideale per la gestante e per la
nanna del bambino. In vendita in esclusiva nel MammaShop.it
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=626&d=16-9
Import Notes
Resolved by subject fallback
On Mon, 16 Sep 2002 08:08:48 +0200, "frank_lupo" <frank_lupo@email.it>
wrote:
Postmaster running by postgres user.
^^^^^^^^
AAdministrator@pippo /usr/share/postgresql/data/pg_xlog
$ ll
total 114688
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 17:36 000000000000008D
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 4 14:16 000000000000008E
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 4 16:40 000000000000008F
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 5 09:40 0000000000000090
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 11 10:35 0000000000000091
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 10:07 0000000000000092
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 15:56 0000000000000093
^^^^^^^^
Frank, these files and the directory pg_xlog (and everything else
under /usr/share/postgresql/data) should be owned by postgres.
HTH.
Servus
Manfred
On Mon, 16 Sep 2002 08:08:48 +0200, "frank_lupo"
wrote:Postmaster running by postgres user.
^^^^^^^^
AAdministrator@pippo /usr/share/postgresql/data/pg_xlog
$ ll
total 114688
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 17:36 000000000000008D
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 4 14:16 000000000000008E
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 4 16:40 000000000000008F
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 5 09:40 0000000000000090
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 11 10:35 0000000000000091
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 10:07 0000000000000092
-rw-r--r-- 1 Administ Nessuno 16777216 Sep 13 15:56 0000000000000093^^^^^^^^
Frank, these files and the directory pg_xlog (and everything else
under /usr/share/postgresql/data) should be owned by p
ostgres.
0D
HTH.
Servus
Manfred
Administrator@pippo /usr/share/postgresql/data
$ ll
total 27
-rw-r--r-- 1 Administ Nessuno 4 Jul 29 06:17 PG_VERSION
drwxr-xr-x 9 Administ Nessuno 0 Sep 11 06:08 base
drwxr-xr-x 2 Administ Nessuno 4096 Sep 17 06:48 global
drwxr-xr-x 2 Administ Nessuno 0 Jul 29 06:17 pg_clog
-rw-r--r-- 1 Administ Nessuno 10130 Jul 29 06:19 pg_hba.conf
-rw-r--r-- 1 Administ Nessuno 1250 Jul 29 06:17 pg_ident.conf
drwxr-xr-x 2 Administ Nessuno 4096 Sep 16 15:28 pg_xlog
-rw-r--r-- 1 Administ Nessuno 3848 Sep 4 14:27 postgresql.conf
-rw-r--r-- 1 Administ Nessuno 59 Sep 16 06:02 postmaster.opts
-rw-r--r-- 1 Administ Nessuno 51 Sep 16 06:02 postmaster.pid
I have tried the commando chown on cygwin, but I have not had no effect. Perhaps it is from using the management
of autho
r
izations of windows ?
Thanks
Bye !!
Frank Lupo (Wolf) !!
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Professionisti per le emergenze quotidiane della casa e della famiglia?
su QXservice trovi idraulici, imbianchini, baby sitter e tanti altri.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=535&d=17-9
Import Notes
Resolved by subject fallback
On Tue, 17 Sep 2002 09:05:41 +0200, "frank_lupo" <frank_lupo@email.it>
wrote:
I have tried the commando chown on cygwin, but I have not had no effect.
Frank, chown works for me here, probably because my user has
administrative rights. Can you log in as administrator and try again?
Servus
Manfred