PostgreSQL Recent threads

Threads	Replies	First post	Last post
Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced By: Craig Ringer Hi all I just had the ... pleasure ... of using Windows with Pg again and was in a usability review frame of mind. I landed up trying to restore my database using PgAdmin-III, and was astonished at how difficult and painful it was. The issues…	1	May 25 2012 04:58	May 25 2012 06:17
Naming conventions By: Scott Briggs So this is purely anecdotal but I'm curious, what's with all the different naming conventions? There's psql (for database connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this mailing list), postgres (user and other references), and…	3	May 15 2012 16:51	May 25 2012 03:50
Is there a way to start postgresql v907 as non daemon process By: Karthik > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. I have observed by default posgresql 8.x onwards starts as daemon process. Is there a way to avoid it. I…	2	May 24 2012 05:09	May 25 2012 03:46
enhanced linestyles for psql By: Pavel Stehule hello I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and border styles to console http://postgres.cz/wiki/Pretty_borders_in_psql Regards Pavel Stehule	6	May 24 2012 08:35	May 24 2012 22:47
missing pg_clog files after pg_upgrade By: Christian J. Dietrich Hey all, I have a problem which I speculate to be due to the pg_upgrade bug [1]: ERROR: could not access status of transaction 13636 DETAIL: could not open file "pg_clog/0000": No such file or directory The pg_clog directory contains files with…	1	May 16 2012 06:28	May 24 2012 20:26
FATAL: lock file "postmaster.pid" already exists By: deepak Hi, On Windows 2008, sometimes the server fails to start due to an existing "postmaster.pid' file. I tried rebooting a few times and even force shutting down the server, and it started up fine. It seems to be a race-condition of sorts in the code…	20	May 7 2012 17:36	May 24 2012 16:45
significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1 By: Lonni J Friedman Greetings, I have a 4 server postgresql-9.1.3 cluster (one master doing streaming replication to 3 hot standby servers). All of them are running Fedora-16-x86_64. Last Friday I upgraded the entire cluster from Fedora-15 with postgresql-9.0.6 to…	14	May 21 2012 16:07	May 24 2012 16:22
Up-to-date reports database By: Herouth Maoz Hi guys, I'm interested in a solution that will allow our customers to run reports - which may involve complicated queries - on data which is as up-to-date as possible. One thing I don't want to do is to let the reporting system connect to the…	2	May 23 2012 08:12	May 24 2012 02:23
Does Postgres compress data? By: Mike Christensen If I run this query: select sum(length(html)) from Indexer.Pages; I get: 15,680,005,116 However, if I type: C:\Program Files\PostgreSQL>dir /s I get: Total Files Listed: 5528 File(s) 7,414,385,333 bytes 575 Dir(s) …	3	May 23 2012 20:08	May 23 2012 20:24
pg_log is 2 hours ahead ??? By: Andreas Hi, I'm running a PG 9.1.3 on OpenSuse 12.1. I found that pg_log is 2 hours ahead though date on the console shows the right date and time. I have the ntp daemon watching the system's time every 60 minutes so this shouldn't be an issue. The…	1	May 23 2012 18:13	May 23 2012 18:18
Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1 By: Tom Lane Gavin Flower <Gavin### @archidevsys.co.nz> writes: >> 16 core Xeon X5550 2.67GHz >> 128GB RAM >> $PGDATA sits on a RAID5 array comprised of 3 SATA disks. Its Linux's >> md software RAID. > How does this compare…	1	May 23 2012 17:34	May 23 2012 17:35
Extreme PostgreSQL? By: Lists We're getting ready to do system upgrades to our postgresql hosting cluster. Currently, we're using 8-core servers with 32 GB of RAM in each to host approximately 75 end user databases per server. I'm wondering if there are particular performance…	1	May 23 2012 16:39	May 23 2012 16:51
One schema per different databases By: Igor Good day. Continuing the subject about DB cluster based on plproxy - a question for developers: Is it possible to manage schema visibility from one database for different databases, at least in the read-only mode ? For example as schema…	1	May 18 2012 03:35	May 23 2012 15:24
Migrating from 8.2 to 9.1 : invalid port number By: Alberto Zanon Hi all, in my production environment I have Postgresql 8.2 + PgPool. The port number I specify in PgPool configuration is not a real portnumber (e.g. 123456). I can define a "dblink" as : dblink('dbname=XXXX host=/var/run port=123456 user=XXXX…	5	May 23 2012 07:58	May 23 2012 11:35
Re: Up-to-date reports database By: Herouth Maoz On 23/05/2012, at 17:20, Chris Ernst wrote: > I would have a look at slony. It is a trigger based replication system > that allows you to replicate only the tables you define and you can have > different indexing on the slave. The only…	2	May 23 2012 10:14	May 23 2012 11:33
main log encoding problem By: yi huang I'm using postgresql 9.1.3 from debian squeeze-backports with zh_CN.UTF-8 locale, i find my main log (which is "/var/log/postgresql/postgresql-9.1-main.log") contains "???" which indicate some sort of charset encoding problem. But error messages…	0	May 22 2012 20:17	May 22 2012 20:17
pg_basebackup blocking all queries By: Lonni J Friedman Greetings, I have a 4 server postgresql-9.1.3 cluster (one master doing streaming replication to 3 hot standby servers). All of them are running Fedora-16-x86_64. Last Friday I upgraded the entire cluster from Fedora-15 with postgresql-9.0.6 to…	2	May 22 2012 13:44	May 22 2012 17:21
Reasons for postgres processes beeing killed by SIGNAL 9? By: Clemens Eisserer Hi, Recently single postgres processes are killed by SIGNAL 9 on our virtual vvmware managed server without any manual interaction - causing lost transactions. Any ideas what could be the reason? Could postmaster the source of the signal? We are…	4	May 17 2012 17:46	May 22 2012 11:55
Why are pg_restore taking that long ? By: Poul Møller Hansen I have just restored a database about 347GB in size postgres=# select * from pg_database_size('dbname'); pg_database_size	5	May 15 2012 10:29	May 22 2012 10:13
why jasperserver has been changed from MySQL to PostGreSQL By: farhad koohbor Why jasperserver has been changed from MySQL to PostGreSQL In previous versions of jasperserver, MySQL was the supporting database but in the jasperserver 4.5 version it changed to PostGreSQL. My question is that why jasperserver changed its mind…	1	May 22 2012 09:35	May 22 2012 09:40