Re: postgres crash

From: frank_lupo <frank_lupo(at)email(dot)it>
To: mkoi-pg <mkoi-pg(at)aon(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres crash
Date: 2002-09-17 07:05:41
Message-ID: H2KMDH$521620BFF267D1E0F9A13D6320855E9C@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mon, 16 Sep 2002 08:08:48 +0200, "frank_lupo"
> wrote:
> >Postmaster running by postgres user.
> ^^^^^^^^
> >AAdministrator(at)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(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Neumann 2002-09-17 07:30:14 Re: STored Procedures
Previous Message Jeff Davis 2002-09-17 06:56:06 Re: Open Source Database article