I'm guessing by the "postmaster.exe" that this is on Windows.
In that case, find "PostgreSQL X.Y" in Control Panel>Administrative
Tools>Services (where X.Y is your major.minor version number of Postgres.)
Change the services' start-up type to "Manual" (so you can start it
yourself when needed.)
Hi all! I have windows XP professional 2003. Yesterday evening I
installed, while turning off my pc, some updates of the os and this
morning the database server does not start!! May some have a trick to
help me? I fund something on the web but too unspecific...
Thanks!!
-
On Wed, 2006-11-15 at 15:13 -0500, Mark Steben wrote:
> Regarding partitioning – I set up a testing table – parent table and 4
> partitioning children’s tables inheriting the
>
> Attributes of the parent. I inserted 1800 rows in all – 450 equitably
> in each partition. The CHECK constraints work
Hello,
I'm not sure what exactly you mean by "starting a standalone
postgres session and using it to recreate your SQL users". Do you mean
running initdb on a new data directory and then trying to create new users?
I'm fairly certain we already tried that. Since
Simon, you're right on the money.. the guys on the IRC chatroom suggested
that I cast the partitioning column as SMALLINT as the optimizer assumed
Integer and it worked. Thx for getting back to me
Mark Steben
AutoRevenue
-Original Message-
From: Simon Riggs [mailto:[EMAIL PROTECTED]
Sent
Will Cameron <[EMAIL PROTECTED]> writes:
> I'm not sure what exactly you mean by "starting a standalone postgres
> session and using it to recreate your SQL users". Do you mean running
> initdb on a new data directory and then trying to create new users?
No, I mean stopping the postmaster, runnin
Why not just have a primary key with 2 columns, one of which is a
serial and the other is a "siteid" or "installid" that is different for
each server?
TomDB wrote:
would there be any default available field (like the OID of the
records) that would be unique in the two versions of the datbas
unsubscribe
IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be
read or used by the named addressee. It is confidential and may contain legally
privileged information. No confidentiality or privilege is waived or lost by
any mistaken transmission to you. The RTA is no
IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be
read or used by the named addressee. It is confidential and may contain legally
privileged information. No confidentiality or privilege is waived or lost by
any mistaken transmission to you. The RTA is not responsi