Re: [ADMIN] Fat16/32 linking problems

2008-09-23 Thread Jonny Rabovsky
Thanks a lot, I converted the filesystem to ext2 . works fine :-) regards, Jonny Rabovsky Tom Lane schrieb: Jonny Rabovsky <[EMAIL PROTECTED]> writes: I have a little trouble with running Postgress on a embedded linux with only Fat availible. I think we assume that link() is a

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Tena Sakai
Hi, As a clueless, optimistic traveller, I'd interpret what Scott's saying as, "maybe slightly less to worry about." Regards, Tena Sakai [EMAIL PROTECTED] -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Tue 9/23/2008 9:21 PM To: Tena Sakai Cc: Carol Walter; pgsql-

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Scott Marlowe
On Tue, Sep 23, 2008 at 10:16 PM, Tena Sakai <[EMAIL PROTECTED]> wrote: > Hi Carol, > > I detect in you some apprehension as to pg_dumpall > won't run or complete. Why is that? Have you already > done it and it didn't work? If that's not the case, > why not run pg_dumpall at a quiet hour and see

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Tena Sakai
Hi Carol, I detect in you some apprehension as to pg_dumpall won't run or complete. Why is that? Have you already done it and it didn't work? If that's not the case, why not run pg_dumpall at a quiet hour and see? I think Scott is right as to install the latest 8.2 on top. It won't be time co

Re: [ADMIN] error

2008-09-23 Thread Carol Walter
I've had no system crashes. I'm embarrassed to say that I may have inadvertently caused this problem when I was do "house cleaning" a couple of weeks ago. When I upgrade, how to I get my data when pg_dumpall won't run? Carol On Sep 23, 2008, at 10:42 PM, Tom Lane wrote: Carol Walter <[EM

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Carol Walter
Hello, Here are the pg_clog files I still have. -rw--- 1 postgres postgres 262144 Jun 4 18:43 0030 -rw--- 1 postgres postgres 262144 Jun 6 02:06 0031 -rw--- 1 postgres postgres 262144 Jun 7 01:26 0032 -rw--- 1 postgres postgres 262144 Jun 7 21:26 0033 -rw---

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Scott Marlowe
On Tue, Sep 23, 2008 at 7:59 PM, Walter, Carol Williams <[EMAIL PROTECTED]> wrote: > Hi, Tena, > > I actually downloaded 8.3.3 last week. The upgrade has been in the plan. I > didn't realize the latest was 8.3.4. I am concerned though. We have so many > dependencies that they never go smoothly.

Re: [ADMIN] error

2008-09-23 Thread Tom Lane
Carol Walter <[EMAIL PROTECTED]> writes: > What would cause this error? > ERROR: could not access status of transaction 10274530 > DETAIL: Could not open file "pg_clog/0009": No such file or directory. We've seen that caused by bugs that made Postgres throw away clog files too soon; but as far

Re: [ADMIN] Fat16/32 linking problems

2008-09-23 Thread Tom Lane
Jonny Rabovsky <[EMAIL PROTECTED]> writes: > I have a little trouble with running Postgress on a embedded linux with > only Fat availible. I think we assume that link() is available on Unix systems, and that probably doesn't work on FAT :-(. Need to find yourself a real Unix file system. (I'm p

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Walter, Carol Williams
Hi, Tena, I actually downloaded 8.3.3 last week. The upgrade has been in the plan. I didn't realize the latest was 8.3.4. I am concerned though. We have so many dependencies that they never go smoothly. Carol Quoting Tena Sakai <[EMAIL PROTECTED]>: Hi Carol, Unless it is impossibly diff

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Tena Sakai
Hi Carol, Unless it is impossibly difficult, I would try to move onto the latest (8.3.4) postgres before the situation worsens. I had followed Scott's advice in the past and never regretted. My two bits, again. Tena Sakai [EMAIL PROTECTED] -Original Message- From: Scott Marlowe [mailt

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Scott Marlowe
On Tue, Sep 23, 2008 at 4:35 PM, Carol Walter <[EMAIL PROTECTED]> wrote: > Hi, Tena, > Yes, you do recall correctly. It is Solaris 10 and Postgres 8.2.3. > I'm going to run a pg_dumpall and keep my fingers crossed. I'm getting > similar errors when I try to do other things like vacuumdb, so maybe

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Carol Walter
Hi, Tena, Yes, you do recall correctly. It is Solaris 10 and Postgres 8.2.3. I'm going to run a pg_dumpall and keep my fingers crossed. I'm getting similar errors when I try to do other things like vacuumdb, so maybe pg_dumpall won't run either. Carol On Sep 23, 2008, at 6:13 PM, Tena Sa

Re: [ADMIN] Missing pg_clog files

2008-09-23 Thread Tena Sakai
Hi Carol, I don't have answer... I have had a similar problem and whatever I did didn't work. As I recall, the files in pg_clog directory started from and the number got bigger by 1 (hex) and there was a gap between the most recent one and the second recent one. (Is that how you know that

[ADMIN] Missing pg_clog files

2008-09-23 Thread Carol Walter
I'm missing about 30 pg_clog files. How do I recover from this? Carol -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] error

2008-09-23 Thread Carol Walter
There really is not pg_clog/0009 file. On Sep 23, 2008, at 4:50 PM, Scott Marlowe wrote: On Tue, Sep 23, 2008 at 2:48 PM, Carol Walter <[EMAIL PROTECTED]> wrote: Hi, Folks, What would cause this error? SQL error: ERROR: could not access status of transaction 10274530 DETAIL: Could not open

Re: [ADMIN] error

2008-09-23 Thread Scott Marlowe
On Tue, Sep 23, 2008 at 2:48 PM, Carol Walter <[EMAIL PROTECTED]> wrote: > Hi, Folks, > What would cause this error? > SQL error: > ERROR: could not access status of transaction 10274530 > DETAIL: Could not open file "pg_clog/0009": No such file or directory. Often it's a problem caused by a vir

[ADMIN] error

2008-09-23 Thread Carol Walter
Hi, Folks, What would cause this error? SQL error: ERROR: could not access status of transaction 10274530 DETAIL: Could not open file "pg_clog/0009": No such file or directory. Carol

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Peter Eisentraut
Devrim GÜNDÜZ wrote: On Tue, 2008-09-23 at 09:49 +0100, Simon Riggs wrote: I'll look at doing that. We need the SUSE builds also. I actually built 8.3.4 on SLES 10.2 on..err..Friday, while building Fedora/RH RPMs. 8.3.1 spec of SLES is broken IMHO, and it requires special attention from someon

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Peter Eisentraut
Dave Page wrote: 2008/9/23 Peter Eisentraut <[EMAIL PROTECTED]>: Gerd König wrote: a few months ago we started using Postgres on Opensuse10.3-64bit. We installed Postgres 8.3.1 with the (at that time) latest available rpm's. But now Postgres' current version is 8.3.4 and I'm wondering why there

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Simon Riggs
On Tue, 2008-09-23 at 21:05 +0300, Devrim GÜNDÜZ wrote: > Hi, > > On Tue, 2008-09-23 at 09:49 +0100, Simon Riggs wrote: > > I'll look at doing that. We need the SUSE builds also. > > I actually built 8.3.4 on SLES 10.2 on..err..Friday, while building > Fedora/RH RPMs. 8.3.1 spec of SLES is broke

Re: [ADMIN] Fat16/32 linking problems

2008-09-23 Thread Joshua Drake
On Tue, 23 Sep 2008 16:07:45 +0200 Jonny Rabovsky <[EMAIL PROTECTED]> wrote: > Hi, > I have a little trouble with running Postgress on a embedded linux > with only Fat availible. > it runs for hours, but the it crashes and I cannot start it again. > Any Ideas ? As I recall, NTFS is required for W

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Devrim GÜNDÜZ
Hi, On Tue, 2008-09-23 at 09:49 +0100, Simon Riggs wrote: > I'll look at doing that. We need the SUSE builds also. I actually built 8.3.4 on SLES 10.2 on..err..Friday, while building Fedora/RH RPMs. 8.3.1 spec of SLES is broken IMHO, and it requires special attention from someone who is experienc

[ADMIN] Please dont subscribe to me

2008-09-23 Thread Jayakumar_Mukundaraju
DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding

[ADMIN] Fat16/32 linking problems

2008-09-23 Thread Jonny Rabovsky
Hi, I have a little trouble with running Postgress on a embedded linux with only Fat availible. it runs for hours, but the it crashes and I cannot start it again. Any Ideas ? LOG: database system was shut down at 2008-09-23 15:32:05 UTC LOG: checkpoint record is at 0/C4643C LOG: redo record

Re: [ADMIN] displaying enum

2008-09-23 Thread Jagadeesh
On Sep 22, 8:56 pm, [EMAIL PROTECTED] (Lennin Caro) wrote: > --- On Mon, 9/22/08, Jagadeesh <[EMAIL PROTECTED]> wrote: > > > From: Jagadeesh <[EMAIL PROTECTED]> > > Subject: [ADMIN] displaying enum > > To: [EMAIL PROTECTED] > > Date: Monday, September 22, 2008, 1:20 PM > > Hi admins, > > > I had cr

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Simon Riggs
On Tue, 2008-09-23 at 10:05 +0100, Dave Page wrote: > On Tue, Sep 23, 2008 at 9:49 AM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > >> Oh, I thought you were looking after that build. If it's not being > >> maintained, we'll need to remove it from the download pages unless > >> someone else can vol

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Dave Page
On Tue, Sep 23, 2008 at 9:49 AM, Simon Riggs <[EMAIL PROTECTED]> wrote: >> Oh, I thought you were looking after that build. If it's not being >> maintained, we'll need to remove it from the download pages unless >> someone else can volunteer? > > I'll look at doing that. We need the SUSE builds al

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Simon Riggs
On Tue, 2008-09-23 at 09:06 +0100, Dave Page wrote: > 2008/9/23 Peter Eisentraut <[EMAIL PROTECTED]>: > > Gerd König wrote: > >> > >> a few months ago we started using Postgres on Opensuse10.3-64bit. > >> We installed Postgres 8.3.1 with the (at that time) latest available > >> rpm's. > >> But now

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Dave Page
2008/9/23 Peter Eisentraut <[EMAIL PROTECTED]>: > Gerd König wrote: >> >> a few months ago we started using Postgres on Opensuse10.3-64bit. >> We installed Postgres 8.3.1 with the (at that time) latest available >> rpm's. >> But now Postgres' current version is 8.3.4 and I'm wondering why there >>

Re: [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Peter Eisentraut
Gerd König wrote: a few months ago we started using Postgres on Opensuse10.3-64bit. We installed Postgres 8.3.1 with the (at that time) latest available rpm's. But now Postgres' current version is 8.3.4 and I'm wondering why there are no new rpm's for Opensuse ?!?! The answer is quite simply th