Thanks again for the replies:
Responding to Kevin, Ian, and Inigo:
1. We'll try an change the order in the script
2. Daily vacuum analyze was disabled, which was running from a different
script, we'll try to put it back.
3. The monthly script does work.
4. In my original email about the
I'm still confused about the disk space, even more so now that more
servers and figures of 1Gb and 15Gb have joined the party.
Presumably this:
3.6M./1
3.6M./16975
51G ./95186722
4.8M./4830693
51G .
is the output from some $ du command. And is this
-rw---1
An Example from another server where the directory grew so big:
/data/postgres7.3.4/data/base/31057006/ directory shows the following size:
4.0K./pgsql_tmp
34G .
A 34GB, it's those tablespaces with different sizes for each in 31057006/
directory.
We dumped the database using
Sorry in my previous comments I meant the reboot does not work or does not
make a difference
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Khangelani Gama
Sent: Thursday, May 06, 2010 11:28 AM
To:
I'm agree with ian.
There is something strange with your filesys...
Can you exec an 'ls -la' ? Perhaps somebody has move something else in
that folder with hidden name ( with a dot in folder name )
And, of course, a fsck should be advisable. :)
-Original Message-
From: Ian Lea
Good afternoon Guys,
I have been reading about RAID for PostgreSQL and some suggestions are:
6 SCSI Disks RAID10 for OS and DB
Or
2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB
I know the more spindles you have the better, but if you are going to be
reading and writing to the same volume
You other option is to use Slony. Create replica and in a short outage you
can move master to replica.
Chirag Dave 416-673-4102
Database Administrator, Afilias Canada Corp.
cd...@ca.afilias.info
On Wed, May 5, 2010 at 11:27 AM, raghu ram raghuchenn...@gmail.com wrote:
Hi Postgres Guru's,
Well, there are quite a few more variables to consider, including:
a) speed of the drives
b) battery backed caching controller or not
c) throughput of the controller channels
d) your particular use
Point d is kind of the most important. We've got about 250 customers talking to
the same
I think it's better to put all disk in a RAID10. Your max throughput
with 6 disks will be a 50% better that with 4 disks, and operating
system once booted, does not have to read/write but a few times.
I would divide RAID volume in several partitions: at least, operating
system (/), swap and
Hello,
LOG: database system was interrupted; last known up at 2010-03-26 11:22:36
CET
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 1F/D2454CD0
The data still seemed to be okay - all the
Which is the appropriate forum for ecpg problems related to postgresql
9.0 beta?
I'm still trying to determine if it is my problem or something new in
9.0 but an existing C program with embedded SQL is not able to connect
to my 9.0 server. Other similar programs are not having any problems
Paul Anderson wrote:
Which is the appropriate forum for ecpg problems related to postgresql
9.0 beta?
I'm still trying to determine if it is my problem or something new in
9.0 but an existing C program with embedded SQL is not able to connect
to my 9.0 server. Other similar programs are
12 matches
Mail list logo