[GENERAL] Postgres fails to start

2008723533/2107262657 left 375921, right 379817, next 376394, level 0, firstright 95 2015-04-07 09:01:44 EST LOG: startup process (PID 2652) exited with exit code 1 2015-04-07 09:01:44 EST LOG: aborting startup due to startup process failure Regards, Haiming Zhang Softwar

Re: [GENERAL] Postgres fails to start

s, Haiming -Original Message- From: Michael Paquier [mailto:michael.paqu...@gmail.com] Sent: Tuesday, 7 April 2015 11:36 AM To: Haiming Zhang Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres fails to start On Tue, Apr 7, 2015 at 9:25 AM, Haiming Zhang wrote: > 2015-04-07

Re: [GENERAL] Postgres fails to start

Hi Michael, Thank you again. It seems hard to recover, I will go the hard way (lost data). Learned a lesson. Regards, Haiming -Original Message- From: Michael Paquier [mailto:michael.paqu...@gmail.com] Sent: Tuesday, 7 April 2015 1:04 PM To: Haiming Zhang Cc: pgsql-general

[GENERAL] Fast way to delete big table?

egards, Haiming [cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png] Haiming Zhang | Engineer | Redflex Group T +61 3 9674 1868 | F +61 3 9699 3566 | E haiming.zh...@redflex.com.au 31 Market Street, (PO Box 720), South Melbourne VIC 3205, Australia If you are not an autho

Re: [GENERAL] Fast way to delete big table?

[cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png] Haiming Zhang | Engineer | Redflex Group T +61 3 9674 1868 | F +61 3 9699 3566 | E haiming.zh...@redflex.com.au 31 Market Street, (PO Box 720), South Melbourne VIC 3205, Australia If you are not an authorised

Re: [GENERAL] Fast way to delete big table?

Hi John, Thanks. Agree, the reindexes will take forever to finish. Do you think increase temp_buffers will help too? Regards, Haiming [cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png] Haiming Zhang | Engineer | Redflex Group T +61 3 9674 1868 | F +61

[GENERAL] Update big table

Hi All, I am using postgres 9.1, I have a question about updating big table. Here is the basic information of this table. 1. This table has one primary key and other 11 columns. 2. It also has a trigger that before update records, another table got updated first.

Re: [GENERAL] Update big table

-Original Message- From: Vincenzo Romano [mailto:vincenzo.rom...@notorand.it] Sent: Sunday, 14 July 2013 9:03 PM To: Haiming Zhang Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Update big table 2013/7/14 Haiming Zhang : > Hi All, > > > > I am using postgres 9.1, I

Re: [GENERAL] Update big table

[mailto:bladeofligh...@gmail.com] Sent: Monday, 15 July 2013 5:26 AM To: pgsql-general@postgresql.org; Haiming Zhang Subject: Re: [GENERAL] Update big table I don't believe you can use JOIN explicitly in this situation because it's an UPDATE, but I believe you can accomplish the same effect wit

[GENERAL] PostgreSQL 9.1 product code

', our product runs without any error. I don not want to change the registry manually in the future. Would anyone please help with how to manage this? Thanks a lot. Haiming Zhang Software Engineer Redflex Traffic Systems Tel: +61 3 9674 1868 Mob: Email: haiming.zh...@redflex.com.

[GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

ows Server 2008, the same issue occured. For Server 2008, my config is: idleConnectionTestPeriod = 60 idleMaxAge = 240 maxConnectionsPerPartition = 100 minConnectionsPerPartition = 5 partitionCount = 5 and in postgresql.conf: max_connections = 2000 shared_buffers = 2G others are as default.