Re: [ADMIN] restoring from dump

2008-08-25 Thread Tena Sakai
Hi Alvaro, I just looked in pg_clog directory and there is only one file: -rw--- 1 postgres postgres 24576 Aug 25 20:18 I saw the same file about 10:30 am and I believe it was roughly the same size. This is a brand new installation of 8.3.3. Regards, Tena Sakai [EMAIL PROTECTED] -

Re: [ADMIN] Regarding access to a user

2008-08-25 Thread Vishal Arora
> Date: Mon, 25 Aug 2008 11:08:14 -0600> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: [ADMIN] Regarding access to a user> CC: [EMAIL > PROTECTED]; pgsql-admin@postgresql.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]> > On Thu, Aug 21, 2008 at 3:05 AM, Shash

Re: [ADMIN] restoring from dump

2008-08-25 Thread Alvaro Herrera
Tena Sakai wrote: > Hi, > > I downloaded the latest release (8.3.3), followed the > instruction on the manual to install and restored the > file I had made by pg_dumpall, thereby bypassing the > trouble with files in pg_clog directory. > > I just read a bit about these files. They are made > as

Re: [ADMIN] Logs perms and ownership

2008-08-25 Thread steve
Correction, perms are 600. On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <[EMAIL PROTECTED]> wrote: > On Tue, 26 Aug 2008 14:11:13 +1200 > Steve Holdoway <[EMAIL PROTECTED]> wrote: > >> On Tue, 26 Aug 2008 10:42:19 +1000 >> <[EMAIL PROTECTED]> wrote: >> >> > Hi all, >> > >> > Is there a way

Re: [ADMIN] Logs perms and ownership

2008-08-25 Thread steve
Yeah, thought about that but as you said the perms on the logs are 700. on both stderr and syslogging. On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <[EMAIL PROTECTED]> wrote: > On Tue, 26 Aug 2008 14:11:13 +1200 > Steve Holdoway <[EMAIL PROTECTED]> wrote: > >> On Tue, 26 Aug 2008 10:42:19 +10

Re: [ADMIN] Logs perms and ownership

2008-08-25 Thread Joshua Drake
On Tue, 26 Aug 2008 14:11:13 +1200 Steve Holdoway <[EMAIL PROTECTED]> wrote: > On Tue, 26 Aug 2008 10:42:19 +1000 > <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > Is there a way to make the postgres logs readable by other users or > > a group apart from postgres:postgres? > > I am on postgres

Re: [ADMIN] Logs perms and ownership

2008-08-25 Thread Steve Holdoway
On Tue, 26 Aug 2008 10:42:19 +1000 <[EMAIL PROTECTED]> wrote: > Hi all, > > Is there a way to make the postgres logs readable by other users or a group > apart from postgres:postgres? > I am on postgres 8.1 > > I cannot see any feature to allow setting perms or ownership > > > Thanks > > Stev

[ADMIN] Logs perms and ownership

2008-08-25 Thread steve
Hi all, Is there a way to make the postgres logs readable by other users or a group apart from postgres:postgres? I am on postgres 8.1 I cannot see any feature to allow setting perms or ownership Thanks Steve -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes t

Re: [ADMIN] restoring from dump

2008-08-25 Thread Tena Sakai
Hi, I downloaded the latest release (8.3.3), followed the instruction on the manual to install and restored the file I had made by pg_dumpall, thereby bypassing the trouble with files in pg_clog directory. I just read a bit about these files. They are made as a result of autovacuum. Does anybod

Re: [ADMIN] Problem with reinstall of PostgreSQL 8.3

2008-08-25 Thread Rommel the iCeMAn
Hi, This happened to me before and the problem was with the 'postgres' Windows account that was created during the first install. If you don't specify a password for this account, the installer will choose a very hard to guess, hard to remember password :-). I logged in as an administrator and

Re: [ADMIN] Regarding access to a user

2008-08-25 Thread Scott Marlowe
On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam <[EMAIL PROTECTED]> wrote: > Dear Vishal > > Thanks for the help but by doing this an error is generated at the time when > the user is trying to log in with the following message: > > " > > Access to database denied > > The server doesn't grant acce

Re: [ADMIN] restoring from dump

2008-08-25 Thread Marcelo Martins
I never tried that and I would be reluctant on doing so since you will be getting status of another transactions. Marcelo Linux/Solaris System Administrator http://www.zeroaccess.org On Aug 24, 2008, at 4:24 PM, Tena Sakai wrote: Hi Marcelo, > What happened to that clog file? was it deleted

Re: [ADMIN] Regarding access to a user

2008-08-25 Thread Lew
Shashwat_Nigam wrote: Dear Tomasz There are others here, too. I had done the same but still the problem is like that the user is able to access all the databases in the current server. Even the order is like same and if I comment the second line(all access) then the error is there. Please p