"Gregory Williamson" <[EMAIL PROTECTED]> writes:
> a) Do I need to dump the database and reload ?
Yes. (Any reasonably modern backend will in fact refuse to start
if pg_control shows an incompatible nameDataLen.) This is not a
lot different from changing --enable-integer-datetimes, for instance.
We need to change the maximum length of table/column name lengths, and it looks
as if changing NAMEDATALEN in src/include/postgres_ext.h and recompiling
postgres.
2 questions:
a) Do I need to dump the database and reload ? (my guess is yes but only a
guess ...)
b) any caveats or warnings abou
Actually I found the answerpg_ctl supports a -w switch which waits for
the start operation to complete.
Decibel...without -w, pg_ctl will return immediately before postmaster is
fully operational. If you don't believe me start the engine and try to
connect to it right away with pgsql(1)...
Ch
On Mon, Aug 13, 2007 at 04:05:37PM -0700, Medi Montaseri wrote:
> Hi,
>
> I am trying to measure startup time of postmaster. Say I have postmaster
Why?
> running on -D /tmp/d1 and would like to restart it on -D /tmp/d2.
>
> If I just say
> time pg_ctl restart -D /tmp/d2
> it will not produce an
--- [EMAIL PROTECTED] wrote:
> > If you need to, you can append your own timestamp to the dump file if you
> > need it.
> >
> > I rolled this functionality into a .bat file.
>
> Hi could you please share how you automated the pg_dump in the command
> line. It seems to always want the password, bu
testing...am I being copied to the list
Medi
Hi Jay
This is the pgADMIN query so you should ask it in that list /
you should try to restart the service in the service panel
Subject: [ADMIN] PgAgent..Date: Tue, 14 Aug 2007 16:44:28 +0530From: [EMAIL
PROTECTED]: pgsql-admin@postgresql.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Dear All
On 8/14/07, Hyatt, Gordon <[EMAIL PROTECTED]> wrote:
> Scott and Tom,
>
> Thanks for your replies. Yes, the missing select keyword was simply a typo
> on my part.
>
> The code that I sent was simplified (I didn't include all the fields, most of
> which are character varying). I've spent all day
[EMAIL PROTECTED] ("Kevin Grittner") writes:
On Tue, Aug 14, 2007 at 6:29 AM, in message
> <[EMAIL PROTECTED]>,
> "Kuriakose, Cinu Cheriyamoozhiyil" <[EMAIL PROTECTED]> wrote:
>> Can anyone please tell me how to download the PostgreSQL-7.1 source code
>> through CVS, i use the following set
Hi Tom,
An excellent suggestion and I've just done it.
Many thanks.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/13/2007 4:21 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postmaster.pid file
"Tena Sakai"
Tena Sakai wrote:
> ~/bin/pg_ctl -D ~/bin reload
It's quite unlikely that your data directory is "~/bin".
> As I looked at the pid file, there were three lines. The
> first line seemed like the pid of the server process. The
> second line indicates where the database cluster resides.
>>> On Tue, Aug 14, 2007 at 8:48 AM, in message
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
wrote:
> I was studying a solution which foresees the 'case when' construct...
> now I can use it in addition to array_to_string . In fact my solution
> failed too if , but if there are some more
> values I
Kuriakose, Cinu Cheriyamoozhiyil wrote:
Hi all,
Please do not start a new thread by replying to someone else's post. This is
called "hijacking" a thread and it has the effect of stopping the conversation
about the original poster's (OP's) point.
Start a new thread by sending a post that is
I've found the problem - I didn't see a misplaced/extra quote_literal.
My bad!
Thanks for the help.
Gord
-Original Message-
From: Hyatt, Gordon
Sent: Tuesday, August 14, 2007 9:18 AM
To: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] plpgsql question/problem
Scott and Tom,
Thanks
>>> On Tue, Aug 14, 2007 at 6:29 AM, in message
<[EMAIL PROTECTED]>,
"Kuriakose, Cinu Cheriyamoozhiyil" <[EMAIL PROTECTED]> wrote:
> Can anyone please tell me how to download the PostgreSQL-7.1 source code
> through CVS, i use the following set of commands to get the source code
> of postgreSQL.
(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
>
>
>
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Hai bisogno di contanti per realizzare i tuoi desideri? Prometeo ti propone
prestiti da 1.500 a 31.000 Euro! Clicca qui per un preventivo immediato.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6916&d=20070814
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tue, 14 Aug 2007, [EMAIL PROTECTED] wrote:
Name, Surname , Job, Hobby, Pet, address
John, Smith, NULL, photo, NULL, NULL
John, Smith, student, NULL, cat, NULL
by using name and surname as selecting key, I want :
John, Smith, student, photo, cat, NULL
If you are sure there's no con
Scott and Tom,
Thanks for your replies. Yes, the missing select keyword was simply a typo on
my part.
The code that I sent was simplified (I didn't include all the fields, most of
which are character varying). I've spent all day yesterday trying to make it
work. (I'm not sure if I mentione
Hi all,
Can anyone please tell me how to download the PostgreSQL-7.1 source code
through CVS, i use the following set of commands to get the source code
of postgreSQL.
1) cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot
login
This command will do an initial login to the PostgreSQL rep
Dear All
If i am trying to start my pgAgent, the following error is occurs...
C:\Program Files\PostgreSQL\8.2\bin>net start pgAgent
The service is not responding to the control function.
More help is available by typing NET HELPMSG 2186.
If any body gone through this errors, kindly give me th
ra in Mondolastminute, centinaia di offerte ti aspettano per le tue
vacanze a prezzi lastminute!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6851&d=20070814
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
21 matches
Mail list logo
