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
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-
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
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
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
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---
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
>>
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
31 matches
Mail list logo