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
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
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
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.
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
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
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/
>> 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