--- On Mon, 12/24/07, Abraham, Danny <[EMAIL PROTECTED]> wrote:
> I can manually create the file "postmaster.pid",
> so the problem
> Does not look like a permission problem.
I had a similar problem once. For some reason, after I installed a windows
service pack update, my Postgresql directory
are you using the same username that you use to start postgres???
M--
- Original Message -
From: "Abraham, Danny" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 24, 2007 9:37 AM
Subject: [TLM] [GENERAL] pg_ctl start fails on Windows
The error message is "could not open PID file".
I c
brian wrote:
Steve Atkins wrote:
On Dec 20, 2007, at 7:35 AM, Gordon wrote:
On Dec 19, 11:32 am, Gordon <[EMAIL PROTECTED]> wrote:
I'm a web developer who does a lot of work in PHP. The back end
database we use is bases on Postgres. I am trying to set my new
MacBook Pro up as a developm
I have struggle for install postgresql ALL versions,but still not success.
Each time it shows "failed to run initdb:1!" at the step init data cluster.
My OS is :windows 2003 sp2.
sorry for my poor english.
---(end of broadcast)---
TIP 4: Have you sear
Hi all,
I have a table like this,
CREATE TABLE mytable(
avarchar(40),
btext,
ctext,
PRIMARY KEY (a, b)
);
What I want to do is:
insert a record into a table, and when the record already
exists(according to the primary key), update it.
I know that there is a ON DUPLICATE clause
Hi,
We are trying to use slony and WAL shipping for warm standby for replication
with postgresql. Currently our systems are in oracle and we r checking the
feasibility to migrate to postgres. Replication is one major issue here.
Though everything seems to be working fine in our test environment, we
Hello,
I am trying to execute a long series of statements within a transaction
in "serializable" isolation level.
I've read Tom Lane's excellent document describing concurrency issues in
Postgres and learned of the general method of doing this:
loop
BEGIN;
SELECT hits FROM webpages WHERE ur
On Tue, 25 Dec 2007, [EMAIL PROTECTED] wrote:
insert a record into a table, and when the record already
exists(according to the primary key), update it.
There is an example that does exactly that, 37-1, in the documentation at
http://www.postgresql.org/docs/current/static/plpgsql-control-stru
On Dec 22, 2007 12:10 AM, Marc <[EMAIL PROTECTED]> wrote:
> Hey Folks,
>
> This query is running really slowly. Sometimes much slower then others.
> I have a feeling that there may be contention on one of the indices it is
> using.
>
> Query and explain plan are below. Seems like it spend the mo
--- On Mon, 12/24/07, Henrique Pantarotto <[EMAIL PROTECTED]> wrote:
> I tried searching the documentation and mailing list, and I
> couldn't
> figure this one out.
ALTER TABLE questions
ALTER COLUMN answers TYPE possible_answers;
Actually your type is fine. you only need to alter the column
--- On Thu, 12/27/07, Thomas Hart <[EMAIL PROTECTED]> wrote:
> Am I the only one seeing very strange send times for the
> last dozen messages or so, or is something else going on with my end
> (maybe my mail server is catching up...)
Even stranger is the fact that most of these posts are prefix
On Dec 27, 2007, at 8:58 AM, Thomas Hart wrote:
Am I the only one seeing very strange send times for the last dozen
messages or so, or is something else going on with my end (maybe my
mail server is catching up...)
It's not just you. [EMAIL PROTECTED] is reinjecting
old mail into the lis
Am I the only one seeing very strange send times for the last dozen
messages or so, or is something else going on with my end (maybe my mail
server is catching up...)
--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)
On Thu, Dec 27, 2007 at 10:49:10AM -0500, Josh Harrison wrote:
> Hi,
> We are trying to use slony and WAL shipping for warm standby for replication
It's unusual to use both. Any reason you want to?
Anyway. . .
> What are the other large 24x7 productions systems that use slony and the
> other WA
On Dec 27, 2007 12:37 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Thu, Dec 27, 2007 at 10:49:10AM -0500, Josh Harrison wrote:
> > Hi,
> > We are trying to use slony and WAL shipping for warm standby for
> replication
>
> It's unusual to use both. Any reason you want to?
We wanted to hav
On Dec 24, 2007, at 11:15 PM, Greg Smith wrote:
This may be better because it isn't doing the query first. You may
discover that you need to aggressively run one of the VACUUM
processes (I'd guess regular and ANALYZE but not FULL) in order to
keep performance steady as the number of r
Note: I've removed -general, since this is really just a Slony discussion.
On Thu, Dec 27, 2007 at 12:49:55PM -0500, Josh Harrison wrote:
> We wanted to have 1 master and 1 slave that can be queried and 1 warm
> standby server that can be brought up in case of crash. So I thought it
> might be be
On Thu, Dec 27, 2007 at 01:08:50PM -0500, Andrew Sullivan wrote:
> Note: I've removed -general, since this is really just a Slony discussion.
err, except I didn't. Apologies for the noise, all.
A
---(end of broadcast)---
TIP 9: In versions below 8
On Thu, 2007-12-27 at 12:49 -0500, Josh Harrison wrote:
>
>
> On Dec 27, 2007 12:37 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Thu, Dec 27, 2007 at 10:49:10AM -0500, Josh Harrison wrote:
> > Hi,
> > We are trying to use slony and WAL shipping for warm standby
>
Steve Atkins wrote:
>
> On Dec 27, 2007, at 8:58 AM, Thomas Hart wrote:
>
>> Am I the only one seeing very strange send times for the last dozen
>> messages or so, or is something else going on with my end (maybe my mail
>> server is catching up...)
>
> It's not just you. [EMAIL PROTECTED] is rei
20 matches
Mail list logo
