[GENERAL] Re: how to set up automatically startup database when the server boot or reboot.

2012-04-28 Thread Jasen Betts
On 2012-04-27, leaf_yxj wrote: > My os is redhat linux 5.5. And My database is greenplum 4.2.1( postgresql > 8.2.15). I will take a look about the init.d directory. if you installed it from the RPM repository it should have installed all it needs. In redhat there should be a command "ntsysv" t

[GENERAL] postgresql log indicate too many execute S_2:COMMIT

2012-04-28 Thread leo xu
Hello: I test postgresql database performance recently,i set log_min_duration_statement=1000; i monitor pg_log file,i find too many execue S_2:commit 10.0.44.21:30170:2012-04-28 11:38:46.340 CSTLOG: duration: 1050.679 ms execute S_2: COMMIT 10.0.44.21:30208:2012-04-28 11:38:46.340 CSTLOG: d

Re: [GENERAL] postgresql standby using pg_archivecleanup don't work

2012-04-28 Thread leo xu
hello: i try it,but it nothing in pg_log.it still don't work! -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-standby-using-pg-archivecleanup-don-t-work-tp5669340p5672191.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

[GENERAL] How to update a newly added column with sub selects?

2012-04-28 Thread J.V.
I need to add a new column to a table (nullable), then populate and then add a not null constraint. The value of the new column is obtained by doing three or more nested sub-selects to get the id that should go into this column. At this point I can add a not null and foreign key constraint.

Re: [GENERAL] How to update a newly added column with sub selects?

2012-04-28 Thread David Johnston
On Apr 27, 2012, at 17:22, "J.V." wrote: > I need to add a new column to a table (nullable), then populate and then add > a not null constraint. > > The value of the new column is obtained by doing three or more nested > sub-selects to get the id that should go into this column. At this point

[GENERAL] Deleting PostGres ID Under Windows XP?

2012-04-28 Thread PostGres
Somewhere along the line the install of one of my apps created a userid named "PostGres", I assume in connection with installing the PostGres database manager. Now I no longer have the option of having the system just boot up into my own ID: I have to select my ID from a login screen that displays

Re: [GENERAL] Deleting PostGres ID Under Windows XP?

2012-04-28 Thread Chris Angelico
On Sun, Apr 29, 2012 at 9:43 AM, wrote: > I'd like to drive a stake through this thing's heart.   I know I > can do it via Control Panel | User Accounts | Delete the account. > > The Question: > > Am I going to regret doing this? If you want to keep using Postgres, yes. Search the web for inform

Re: [GENERAL] Deleting PostGres ID Under Windows XP?

2012-04-28 Thread PostGres
RE/ >> Am I going to regret doing this? > >If you want to keep using Postgres, yes. Search the web Suspicion.. *Confirmed*. Thanks! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-gener