Στις Τετάρτη 31 Οκτώβριος 2007 23:47, ο/η Scott Marlowe έγραψε:
> On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > � 30 � 2007 10:45, �/� Patrick De
Zlio ��:
> > > Hi,
> > >
> > > We are running PostgreSQL 8.2.4 with quite highly updated millions rows
> > > table
Hi,
I need to drop database.
"drop database" does not always work, since user connections to the
database still exist
(I get : ERROR: database "yuval" is being accessed by other users , SQL
state: 55006)
How can I force the drop ? or is there a way to kill database
connection and then to
Hello Frnds,
Is there any way to Convert the Number to its equivalent String
( Words)
e.g. 10 to TEN.
Urgent require the Answer..
Regards,
Yogesh Arora
---(end of broadcast)---
TIP 6: explain analyze is your friend
"Mohamed Yassin Eltabakh" <[EMAIL PROTECTED]> writes:
> But when I try to "initdb" it gives me the following error:
> The program "postgres" is needed by "initdb" but was not found in the same
> directory as "/cygdrive/c/PostgresInstallation/pgsql/bin/initdb" Check your
> installation.
What happ
On 11/1/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> Στις Î¤ÎµÏ„Î¬Ï Ï„Î· 31 ÎŸÎºÏ„ÏŽÎ²Ï Î¹Î¿Ï‚ 2007 23:47, ο/η Scott Marlowe
> ÎÎ³Ï Î±ÏˆÎµ:
> > On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > > Óôéò Ôñßôç 30 Ïêôþâñéïò 2007 10:45, ï/ç Patrick De
> Zlio Ýãñáøå:
> > > > H
"Mohamed Yassin Eltabakh" <[EMAIL PROTECTED]> writes:
>> What happens if you try "postgres -V" by hand?
> The response is nothing (empty). No version number appears.
Well, that's why initdb is not happy, but the next question is why
linking in libxml2 breaks postgres that thoroughly. No idea on
>> I have been pushing for 3 years to upgrade this database, and with some
>> upcoming projects, I am going to do another push with management to upgrade
>> this database.
>
> Push hard. They'll thank you later.
No they won't. They have been running this way fine for years - if they
haven't cras
The response is nothing (empty). No version number appears.
Thanks
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Mohamed Yassin Eltabakh" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, November 01, 2007 10:36 AM
Subject: Re: [ADMIN] postgres8.3 and libxml2
"Mohamed Yassin
Hi List;
I'm wanting to better understand wal / checkpoint segments.
I have a cluster which has checkpoint_segments set to 32 and wal_buffers set
to 24.
I see consistently 66 files in pg_xlog and I've recently implemented wal
archiving and so far there are 41 segments/files in the wal archive
Kevin Kempter <[EMAIL PROTECTED]> writes:
> What's the relationship between wal_buffers and checkpoint_segments?
None particularly.
> even
> though the max distance between checkpoints is 32 segments, is there
> something that controls the number of files/segments in the pg_xlog dir ?
The syst
On Thursday 01 November 2007 22:38:02 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > What's the relationship between wal_buffers and checkpoint_segments?
>
> None particularly.
>
> > even
> > though the max distance between checkpoints is 32 segments, is there
> > something that co
Kevin Kempter <[EMAIL PROTECTED]> writes:
> One more question. I see a fair amount of file changed warnings in the tar
> output. Like this:
> tar: ./data/base/82097725/4242350944: file changed as we read it
Yeah, GNU tar complains about that. It's not a problem, other than the
risk that a boatl
Kevin Kempter <[EMAIL PROTECTED]> writes:
> Also I suspect after each filesystem backup I should remove the older
> archived segments since the file system backup makes them
> irrelevant. Is this accurate?
Depends what your goals are. If you only want to be able to recover
the latest database sta
On Thursday 01 November 2007 23:38:48 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > Also I suspect after each filesystem backup I should remove the older
> > archived segments since the file system backup makes them
> > irrelevant. Is this accurate?
>
> Depends what your goals are
PostgreSQL: 8.2.4
OS: Linux Enterprise 4
Is there a way to log into PostgreSQL and determine how many database
connections are in use? I know how many I have allocated in the
postgresql.conf file. I would think there is some command in SQL or
command line parameter that would tell me how man
On Thursday 01 November 2007 23:52:00 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > One more question. I see a fair amount of file changed warnings in the
> > tar output. Like this:
> >
> > tar: ./data/base/82097725/4242350944: file changed as we read it
>
> Yeah, GNU tar complain
16 matches
Mail list logo