"Tena Sakai" <[EMAIL PROTECTED]> writes:
> Does checkpoint not happen if there is no activity?
That's correct.
regards, tom lane
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Jessica Richard <[EMAIL PROTECTED]> writes:
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> If this a Postgres disconnection or a disconnection on the OS side?
Well, you can't tell for c
In other words, are you sure you want to use 7.1 which is about 5 years old
?
Also note that there are binary versions for various platforms, ready to be
used.
Cheers
Medi
On 8/20/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Kuriakose, Cin
Hi Farhan,
> Are you facing any problems?
Yes, the files in data/pg_xlog directory hasn't been
updated. Here's the setting as far as checkpint
entries are concerned:
checkpoint_segments = 3
checkpoint_timeout = 5min
checkpoint_warning = 30s
Does checkpoint not happen if there is no activ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kuriakose, Cinu Cheriyamoozhiyil wrote:
> Hi,
>
>
>
> I was in the process of downloading the source code of PostgreSQL-7.1
> through CVS, and I was able to do that with the command :
>
>
>
> cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroo
Hi,
I was in the process of downloading the source code of PostgreSQL-7.1
through CVS, and I was able to do that with the command :
cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot co
-rREL7_1 -P pgsql
Now this source code is downloaded is in the pgsql folder, can anyone
please te
Perhaps you could try to express your idea in SQL language (as much as
possible, call it pseudo SQL) and then ask for optimization suggestion
Cheers
Medi
On 8/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I agree, but now I actually need a technical and syntactical support in
Hi all,
I agree, but now I actually need a technical and syntactical support in
order to grab all my queries to keep the php code simple and fast. This is
the scenario:
I send as input three parameters: x,y,z (one or two could be null)
1th query on human anagrafic table(S) regarding x,y,z -> 1t
A reload should be enough. Are you facing any problems?
--Farhan
- Original Message
From: Tena Sakai <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Sent: Tuesday, 21 August, 2007 5:00:21 AM
Subject: [ADMIN] After adjusting checkpoint related entries in
postgresql.conf...
After adj
Hi everybody,
After adjusting checkpoint related entries in postgresql.conf
file, is it sufficient to issue:
pg_ctl reload
Or am I supposed to do more than that?
Thank you in advance.
Tena Sakai
[EMAIL PROTECTED]
On 8/20/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
> Sometime a script talking to the Postgres has already been killed on the OS
> level, but the Postgres for this script is still listed out of select * from
> pg_stat_activity, saying a particular database is still being accessed by
> this scri
Sometime a script talking to the Postgres has already been killed on the OS
level, but the Postgres for this script is still listed out of select * from
pg_stat_activity, saying a particular database is still being accessed by this
script.
How to kill (release) this connection in this case?
Th
A psql connection was started from one Linux machine, talking to the Postgres
server on another Linux machine (both the postgres client and the Postgres
server are 8.2.4). Got the following error:
If this a Postgres disconnection or a disconnection on the OS side?
Thanks!!!
server closed th
Currently running v7.4.8 postgres on a RHE Linux 4.0 box. Will be
upgraded to postgres 8.2.x sometime this fall.
Several of the tables in the database that resides on this system have
lots of inserts and updates. Very little is deleted at this time, as
the database is intended for archiving
Hi!
I want to vacuum analyze a number of tables in a given database (on
port 5432) from a shell script. There is no need to process the whole
database.
Using
vacuumdb -d mydb -t mytab1 -t mytab2 -t mytab3 -fzp 5432;
silently operates on the last tablename given only. 'mytab3' in the
example ab
On 8/20/07, Medi Montaseri <[EMAIL PROTECTED]> wrote:
> You can think of a database as a filesystem as well. That is do some
> processing, store the result in temp table, do some more, etc,etc then merge
> and process temp tables to arrive at some result.
>
> Just as in the case of filesystem, if y
In REGALO un GIOCO! Scegli GPBikes 3D,Bubble Boom, Rock City Empire
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6732&d=20070820
>
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
On 8/20/07, luis perruca <[EMAIL PROTECTED]> wrote:
>
> Hi All: I'm From Spain and I'll try to write in english as best as possible:
Your english > my spanish, so please don't worry.
> I'm new in the list, and I have a serious problem: I am novice with
> Postgresql and I haven't found any solutio
Hi,
I'm not a specialist in Postgres, but I would do the following:
1. Backup your data directories and install the old version of
postgres (8.0.1). It seems,
that the format of the data files has been changed.
2. Restore your data files. If you have luck, then your database
should be working.
3.
1, max(c2) from
> testtable group by c1 );
>
>
> HTH
>
> Ben K.
> Developer
> http://benix.tamu.edu
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgre
If I understand you right I think what you want is
select c1,c2,c3,c4,c5 from table1 intersect select c1,c2,c3,c4,c5 from
table2
On 19/08/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I need to implement a filter in order to select from the first table the
> second one...
> it could
On 8/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi,
> I need to implement a filter in order to select from the first table the
> second one...
> it could be simple, but i'm wasting time. Please, is there anyone could help
> me?
> thanks in advance
> Giu
>
> c1 c2 c3 c4 c5
>
On Sun, 19 Aug 2007, [EMAIL PROTECTED] wrote:
Hi,
I need to implement a filter in order to select from the first table the
second one...
c1 c2 c3 c4 c5
1)133659;1;"0039";"00121";7
2)133664;1;"0039";"00121";12
3)133664;2;"0039";"00121";12
4)133665;2;"0039";"00121";12
5)135460;1;"0039
Tom Lane wrote:
> Pallav Kalva <[EMAIL PROTECTED]> writes:
>
>> We are planning on upgrading to postgres 8.2.4 from 8.0, we are
>> seeing some errors like "invalid string enlargement request size
>> 1476395004" after upgrade.
>>
>
> This seems like it must be a server bug, and yet this
Hi,
I need to implement a filter in order to select from the first table the
second one...
it could be simple, but i'm wasting time. Please, is there anyone could help
me?
thanks in advance
Giu
c1 c2 c3 c4 c5
1)133659;1;"0039";"00121";7
2)133664;1;"0039";"00121";12
3)133664;2;"0039"
Hi All: I'm From Spain and I'll try to write in english as best as
possible:
I'm new in the list, and I have a serious problem: I am novice with
Postgresql and I haven't found any solution.
I Wil descrive the scenario:
I have Postgresql 8.0.1 running on Windows 2003 Server.
I have a Backup of my
a PHP?
thanks in advantage
giu
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
In REGALO un GIOCO! Scegli GPBikes 3D,Bubble Boom, Rock City Empire
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6732&d=20070820
-
Le vendredi 17 août 2007, Hilton Perantunes a écrit :
> Exactly what happened, Peter. Something was preventing me of successfully
> install 8.2.4 through apt-get, so I did it by hand.
Maybe you're using debian stable, in which case you'd have to use some
backport of PostgreSQL to get 8.2.4. Or si
28 matches
Mail list logo
