[GENERAL] Looking at the contents of a WAL file

Postgres 9.0 on Solaris 10. Is there any meaningful way to check the contents of a WAL file? I had a server run out of space and I wanted to check the WAL files to see what was going on that filled up the disk space. No errors in the log file so whatever was running was running "error free" unti

[GENERAL] Backups with continuous archiving

Using Postgres 9.0.3 on Solaris 10 (Sparc). I have a few questions concerning hot backups with continuous archiving. We have read and think we understand the Postgres documentation on backup and restore located here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html We

[GENERAL] How do you stop the log from rotating on restart?

Postgres 9.0.3 on Solaris 10 Can't seem to figure out how to stop the postgres log file from rotating on a restart of services. log_truncate_on_rotation is commented out log_rotation_age = 1d We just want it to rotate once a day no matter haw many times we restart. Don't see anything else

[GENERAL] Fwd: Can't get a simple COPY to work

> I'm getting really frustrated, I can't get a simple COPY > command to work. I've tried running psql and both the > postgres user and the owner of the database with the same error. Sorry about the, I see the file name requires a quote.

[GENERAL] Can't get a simple COPY to work

I'm getting really frustrated, I can't get a simple COPY command to work. I've tried running psql and both the postgres user and the owner of the database with the same error. psql -U postgres -d database1 database1=# BEGIN; BEGIN database1=# TRUNCATE TABLE grades; TRUNCATE TABLE datab

Re: [GENERAL] How do you change the size of the WAL files?

>> > Our WAL files are 16 Mb in size each. I cannot find where you >> > configure them to make them larger. 16 Mb is too small for our >> > instalation. If necessary, I can rebuild the entire cluster. Our >> > DBA initialized a new cluster and specified a larger WAL size but it >> > stayed

Re: [GENERAL] How do you change the size of the WAL files?

>> > Our WAL files are 16 Mb in size each. I cannot find where you >> > configure them to make them larger. 16 Mb is too small for our >> > instalation. If necessary, I can rebuild the entire cluster. Our >> > DBA initialized a new cluster and specified a larger WAL size but it >> > stay

Re: [GENERAL] How do you change the size of the WAL files?

>> Our WAL files are 16 Mb in size each. I cannot find where you >> configure them to make them larger. 16 Mb is too small for our >> instalation. If necessary, I can rebuild the entire cluster. Our >> DBA initialized a new cluster and specified a larger WAL size but it >> stayed at

[GENERAL] How do you change the size of the WAL files?

Our WAL files are 16 Mb in size each. I cannot find where you configure them to make them larger. 16 Mb is too small for our instalation. If necessary, I can rebuild the entire cluster. Our DBA initialized a new cluster and specified a larger WAL size but it stayed at 16 Mb. Any info o

[GENERAL] Mounting file system for WAL on Solaris 10

PostgreSQL 9.0.3 on Solaris 10 Sparc I have moved the WAL to a separate file system and set the forcedirectio option per popular recommendation. My question is this: As standard operating procedure in our shop, whenever we mount a UFS file system, we use the "logging" option. Is there a

[GENERAL] First production install - general advice

I'm going to go live with my first production install of PostgreSQL 9.0 in about a week. I've done a LOT of reading on the internet and I've purchased two very good reference books and actually read them: PostgreSQL 9 Administration Cookbook PostgreSQL 9.0 High Performance I'd like to kno

[GENERAL] Significance of USE_FLOAT8_BYVAL ?

Using the 9.0.3 binaries from the PostgreSQL download site, Solaris 10 on Sparc architecture. I had a co-worker set up a development server using the 32 bit PostgreSQL binaries for Solaris 10 Sparc. After some initial testing we realized we can't take full advantage of the 16 GB of syste

Re: [GENERAL] Index names not consistent

> Running postgres 9.0.1 on Solaris 10 (Sparc) > I am testing a development database before putting it in production. The application install created the database and the indexes. When I run psql and list the indexes \di I can count the number of indexes and see the names of the indexes.

[GENERAL] Index names not consistent

Running postgres 9.0.1 on Solaris 10 (Sparc) I am testing a development database before putting it in production. The application install created the database and the indexes. When I run psql and list the indexes \di I can count the number of indexes and see the names of the indexes. If