pgsql-general - March 2012

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

March 1, 2012

Thread	Author	Time
Re: "invalid memory alloc request size" + "Could not open file "pg_clog/XXXX"	Albe Laurenz	09:05
Re: what Linux to run	Vincent Veyron	11:19
Re: what Linux to run	Ivan Voras	12:25
Re: what Linux to run	Ivan Voras	12:33
Allowed DML on replicas?	François Beausoleil	13:24
2 x duplicate key value violation: which exception comes first ?	Marc Mamin	13:41
Re: Problem with initdb and two versions on one server?	Chris McCormick	13:52
Re: Privilege on schema 'public' not revokable	Vincent de Phily	14:14
"Compressed data is corrupt"	Matthias Leisi	14:18
Re: Allowed DML on replicas?	Guillaume Lelarge	14:47
Re: what Linux to run	Scott Marlowe	15:21
100% cpu usage on some postmaster processes kill the complete database	Paul Dunkler	16:41
Re: 100% cpu usage on some postmaster processes kill the complete database	Richard Huxton	17:02
Ident authentication failed for user	Ruben Blanco	17:02
Re: accumulating handles problem on machine running postgresql	Adam Bruss	17:20
Re: Ident authentication failed for user	John R Pierce	17:25
Re: Ident authentication failed for user	Ruben Blanco	18:03
Re: Ident authentication failed for user	John R Pierce	18:07
Re: 100% cpu usage on some postmaster processes kill the complete database	Paul Dunkler	19:41
Re: 100% cpu usage on some postmaster processes kill the complete database	Richard Huxton	20:16
Re: 100% cpu usage on some postmaster processes kill the complete database	Paul Dunkler	20:52
Re: 100% cpu usage on some postmaster processes kill the complete database	Scott Marlowe	21:14
Re: 2 x duplicate key value violation: which exception comes first ?	Tom Lane	21:47
Re: "Compressed data is corrupt"	Tom Lane	21:50
pg_upgrade + streaming replication ?	Lonni J Friedman	22:01
Split read/write queries between 2 servers (one master and one slave with streaming replication)?	Benjamin Henrion	22:06
Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)? 📎	Adam Cornett	22:30

March 2, 2012

Thread	Author	Time
Re: archive_cleanup_command recovery.conf Standby server error	chinnaobi	08:28
Quoted strings on CLI	Alexander Reichstadt	08:59
Re: Quoted strings on CLI	Pavel Stehule	09:14
Re: Quoted strings on CLI	Alexander Reichstadt	10:05
Re: Yearly date comparison?	Vincent Veyron	10:17
Restoring selected records from backup file	Piyush Lenka	10:20
Problems with non use of indexes	Tyler Durden	12:12
Re: Problems with non use of indexes	Tomas Vondra	12:23
Re: Problems with non use of indexes	Tyler Durden	12:45
Re: Problems with non use of indexes	Tomas Vondra	12:55
Re: Problems with non use of indexes	Tyler Durden	13:34
Re: Problems with non use of indexes	Tomas Vondra	14:23
Re: Problems with non use of indexes	Tyler Durden	14:55
Re: archive_cleanup_command recovery.conf Standby server error	Adrian Klaver	15:11
Re: what Linux to run	Volodymyr Kostyrko	15:20
Opposite function of hstore each function	ChoonSoo Park	16:50
Re: Opposite function of hstore each function	Bosco Rama	17:19
Re: Opposite function of hstore each function	ChoonSoo Park	18:12
concatenating text and bytea	Vincent de Phily	18:19
Re: concatenating text and bytea	Tom Lane	18:58
|| versus concat( ), diff behavior	david.sahagian	20:58
Re: || versus concat( ), diff behavior	Ben Chobot	21:14
Re: || versus concat( ), diff behavior	Philip Couling	21:46
Re: || versus concat( ), diff behavior	David Johnston	22:10
role missing in dump	Thomas Prause	22:39
Re: role missing in dump	Adrian Klaver	23:14
Re: Restoring selected records from backup file	Adrian Klaver	23:21
Re: role missing in dump	Thomas Prause	23:30

March 3, 2012

Thread	Author	Time
Re: what Linux to run	Gavin Flower	00:43
Re: what Linux to run	Leif Biberg Kristensen	10:33
Re: what Linux to run	Gavin Flower	10:55
Re: what Linux to run	Chris Travers	10:56
Content management system to build web site with PostgreSql, should it be WordPress	Andrus	11:16
Re: what Linux to run	Raymond O'Donnell	11:34
Re: what Linux to run	Chris Angelico	11:36
Re: Content management system to build web site with PostgreSql, should it be WordPress	Raymond O'Donnell	11:41
Re: what Linux to run	Leif Biberg Kristensen	11:49
Re: what Linux to run	Scott Marlowe	12:11
Re: what Linux to run	Scott Marlowe	12:14
Re: what Linux to run	Scott Marlowe	12:17
Re: Problems with non use of indexes	Scott Marlowe	12:27
BUG #6510: A simple prompt is displayed using wrong charset	exclusion	18:44
Mix characters with utf-8 characters on the same query	Daniel Vázquez	20:22
Re: what Linux to run	John R Pierce	20:49
Re: what Linux to run	David Boreham	21:15
Re: what Linux to run	Gavin Flower	21:42
Create topology from a shape file	ArArgyridis	22:32

March 4, 2012

Thread	Author	Time
Re: what Linux to run	Tom Lane	02:05
Re: what Linux to run	David Boreham	02:23
Re: what Linux to run	Jon Nelson	02:36
Re: what Linux to run	Brent Wood	02:49
Re: what Linux to run	Chris Angelico	02:55
Re: what Linux to run	Chris Travers	03:01
Re: what Linux to run	John R Pierce	03:39
Re: what Linux to run	Chris Travers	03:49
Re: what Linux to run	Scott Marlowe	04:36
Re: what Linux to run	Devrim GÜNDÜZ	10:30
Create topology from a shape file	ArArgyridis	16:53
Re: || versus concat( ), diff behavior	c k	18:26
Re: || versus concat( ), diff behavior	David Johnston	18:44
Return unknown resultset from a function	Jan Meyland Andersen	19:52
Re: Return unknown resultset from a function	Pavel Stehule	19:57
Re: Return unknown resultset from a function	David Johnston	20:00
Re: || versus concat( ), diff behavior	Tom Lane	20:11
Re: Return unknown resultset from a function	Rory Campbell-Lange	20:43
Re: Return unknown resultset from a function	Rory Campbell-Lange	20:58

March 5, 2012

Thread	Author	Time
atoi-like function: is there a better way to do this?	Chris Angelico	02:13
Re: atoi-like function: is there a better way to do this?	Chris Angelico	03:31
Re: atoi-like function: is there a better way to do this?	David Johnston	03:50
Re: atoi-like function: is there a better way to do this?	Chris Angelico	04:06
Re: atoi-like function: is there a better way to do this?	Tom Molesworth	04:15
Re: atoi-like function: is there a better way to do this?	Chris Angelico	05:08
Re: atoi-like function: is there a better way to do this?	David Johnston	05:13
SELECT FOR UPDATE could see commited trasaction partially.	Sam Wong	06:41
Re: SELECT FOR UPDATE could see commited trasaction partially.	Kiriakos Georgiou	09:21
Re: atoi-like function: is there a better way to do this?	Tom Molesworth	09:30
Determine dead files	Andreas Brandl	10:58
Re: what Linux to run	r d	12:25
Memory usage and configuration settings	Mike C	12:37
Non inheritable check constraint	Clodoaldo Neto	13:19
Re: Return unknown resultset from a function	Merlin Moncure	14:36
Re: what Linux to run	mgould	15:05
Re: Memory usage and configuration settings	Tom Lane	16:04
Re: Return unknown resultset from a function	Tom Lane	16:08
Re: Memory usage and configuration settings	Mike C	17:03
Re: Memory usage and configuration settings	Tom Lane	17:13
Re: Return unknown resultset from a function	Merlin Moncure	19:34

March 6, 2012

Thread	Author	Time
Re: Memory usage and configuration settings	Merlin Moncure	00:01
Single server multiple databases - extension	Brian Trudal	00:52
Lost data Folder, but have WAL files--- How to recover the database ?? Windows	chinnaobi	02:38
Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows	Chris Travers	03:11
ANALYSE on top-level of partitioned tables - required?	Toby Corkindale	04:52
pg_dump : no tables were found.	Piyush Lenka	06:22
Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows	Simon Riggs	08:53
Re: [ADMIN] pg_dump : no tables were found.	Julien Rouhaud	10:44
Re: what Linux to run	Gavin Flower	10:45
corrupted table postgresql 8.3	Matteo Sgalaberni	15:15
Unhelpful initdb error message	Thom Brown	15:46
Re: Unhelpful initdb error message	Tom Lane	16:02
Re: Unhelpful initdb error message	Adrian Klaver	16:04
Re: Unhelpful initdb error message	Thom Brown	16:05
Re: Unhelpful initdb error message	Thom Brown	16:11
Re: Unhelpful initdb error message	Thom Brown	16:18
Re: Unhelpful initdb error message	Adrian Klaver	16:18
Re: Unhelpful initdb error message	Thom Brown	16:24
Re: Unhelpful initdb error message	Tom Lane	16:31
Re: Unhelpful initdb error message	Thom Brown	16:39
Re: Unhelpful initdb error message	Adrian Klaver	16:40
Re: Unhelpful initdb error message	Thom Brown	16:44
Adding a lot of tables	jan.musial	16:58
Re: Unhelpful initdb error message	Adrian Klaver	17:00
Re: Unhelpful initdb error message	Thom Brown	17:09
Re: Unhelpful initdb error message	Tom Lane	17:16
Re: Unhelpful initdb error message	Adrian Klaver	17:19
Re: Unhelpful initdb error message	Thom Brown	17:25
Re: Unhelpful initdb error message	Tom Lane	17:43
Re: Unhelpful initdb error message	Adrian Klaver	17:45
Re: Unhelpful initdb error message	Tom Lane	17:46
Re: Unhelpful initdb error message	Adrian Klaver	17:48
Re: Unhelpful initdb error message	Thom Brown	17:48
Re: Unhelpful initdb error message	Thom Brown	17:51
Re: Unhelpful initdb error message	Tom Lane	17:53
Re: Unhelpful initdb error message	Adrian Klaver	17:58
Re: Unhelpful initdb error message	Thom Brown	18:00
Re: Unhelpful initdb error message	Adrian Klaver	18:01
Re: Unhelpful initdb error message	Thom Brown	18:03
Re: Unhelpful initdb error message	Magnus Hagander	18:08
Re: Unhelpful initdb error message	Tom Lane	18:10
Re: Unhelpful initdb error message	Bosco Rama	18:12
Re: Unhelpful initdb error message	Tom Lane	18:20
Re: Adding a lot of tables	Raymond O'Donnell	18:25
Re: Unhelpful initdb error message	Thom Brown	18:51
Re: Unhelpful initdb error message	dennis jenkins	18:51
Re: Unhelpful initdb error message	Thom Brown	19:00
Re: Unhelpful initdb error message	Tom Lane	19:28
Complex transactions without using plPgSQL Functions. It is possible?	Andre Lopes	19:30
Re: Complex transactions without using plPgSQL Functions. It is possible?	Adrian Klaver	19:37
Re: Unhelpful initdb error message	Thom Brown	19:43
Re: Unhelpful initdb error message	Bosco Rama	19:44
Re: Unable to write inside TEMP environment variable path	hello_world	19:57
Re: Single server multiple databases - extension	Brian Trudal	20:00
corrupted table postgresql 8.3	Matteo Sgalaberni	20:24
Re: Complex transactions without using plPgSQL Functions. It is possible?	Chris Angelico	20:57
Re: corrupted table postgresql 8.3	Tomas Vondra	21:02
Re: Single server multiple databases - extension	Bartosz Dmytrak	21:02
Re: Complex transactions without using plPgSQL Functions. It is possible?	Tom Lane	22:25
Re: Complex transactions without using plPgSQL Functions. It is possible?	Chris Angelico	22:48
replication between US <-> EU	Ondrej Ivanič	23:31
Re: replication between US <-> EU	John R Pierce	23:36
Re: Single server multiple databases - extension	Brian Trudal	23:48

March 7, 2012

Thread	Author	Time
Re: Single server multiple databases - extension	Tom Lane	00:09
Re: replication between US <-> EU	Ondrej Ivanič	00:12
Re: corrupted table postgresql 8.3	Matteo Sgalaberni	00:34
Re: Single server multiple databases - extension	Brian Trudal	00:39
A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?	Aleksey Tsalolikhin	03:05
Synchronous replication + Fusion-io = waste of money OR significant performance boost? (compared to normal SATA-based SSD-disks)?	Joel Jacobson	08:54
ERROR: could not find tuple for trigger 37463634	mdione.ext	10:18
Re: Complex transactions without using plPgSQL Functions. It is possible?	Sergey Konoplev	10:19
Re: ERROR: could not find tuple for trigger 37463634	mdione.ext	10:27
Re: Complex transactions without using plPgSQL Functions. It is possible?	Martin Gregorie	11:55
SQL Normalization Thought	David Johnston	12:34
Re: ERROR: could not find tuple for trigger 37463634	mdione.ext	13:10
Re: SQL Normalization Thought	dennis jenkins	14:03
Fixing the loss of 'template1'	Martin Gregorie	14:23
Re: Fixing the loss of 'template1'	Gary Chambers	14:38
Re: Fixing the loss of 'template1'	Marti Raudsepp	14:43
Re: Fixing the loss of 'template1'	Gary Chambers	14:53
rounding a timestamp to nearest x seconds	Andy Colson	15:09
Re: Fixing the loss of 'template1'	Adrian Klaver	15:10
Re: ERROR: could not find tuple for trigger 37463634	Tom Lane	15:12
Re: Fixing the loss of 'template1'	Martin Gregorie	15:19
Re: Fixing the loss of 'template1'	Adrian Klaver	15:22
Re: Fixing the loss of 'template1'	Adrian Klaver	15:32

Browse Archives

Prev | Next