On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer wrote:
> Hi,
>
> is there a reason why pg_stat_activity is not documented in the chapter
> "System Catalogs"?
> Is this not a "offical" view?
It's not a catalog, it's a statistics view. It's documented in "26.2.
The Statistics Collector", specifically
> Well SIGPIPE is no help since it would only fire if we tried to write
> to the socket anyways.
Right. For this purpose, pgpool sends param packet to client
periodically while waiting for a reply from backend to detect if the
connection to the client is broken. If it's broken, pgool sends cancel
Hi.
I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
I opened the posgres SQL to accept incoming connections:
listen_addresses = '*'
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port =
Dotan Barak wrote:
Hi.
I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
I opened the posgres SQL to accept incoming connections:
listen_addresses = '*'
# comma-separated list of addresses;
# defaults to 'localhos
Magnus Hagander, 30.07.2009 09:24:
On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer wrote:
Hi,
is there a reason why pg_stat_activity is not documented in the chapter
"System Catalogs"?
Is this not a "offical" view?
It's not a catalog, it's a statistics view. It's documented in "26.2.
The Stati
On Thu, Jul 30, 2009 at 8:41 AM, Tatsuo Ishii wrote:
>> Well SIGPIPE is no help since it would only fire if we tried to write
>> to the socket anyways.
>
> Right. For this purpose, pgpool sends param packet to client
> periodically while waiting for a reply from backend to detect if the
> connectio
On Thu, Jul 30, 2009 at 7:43 AM, Craig
Ringer wrote:
> On Wed, 2009-07-29 at 14:56 +0100, Greg Stark wrote:
>
>> SIGURG might be useful but it would be more complex to use and less
>> widely useful since it would only work if the client disconnects
>> gracefully (though it might be worth checking i
Thanks for the quick response.
On Thu, Jul 30, 2009 at 11:26 AM, Richard Huxton wrote:
> Dotan Barak wrote:
>>
>> Hi.
>>
>> I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
>>
>> I opened the posgres SQL to accept incoming connections:
>>
>>
>> listen_addresses = '*'
>>
Dotan Barak wrote:
grep on what?
(on ps: there isn't anything).
I was thinking of something like:
# find /etc -type f -print0 | xargs -0 grep 17583
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Thu, Jul 30, 2009 at 10:27 AM, Csaba Nagy wrote:
>
> Sorry, I have to disagree here. If there's a spurious network error, you
> have usually bigger problems. I prefer to have the connection killed
> even if the network recovers
I know this is a popular feeling. But you're throwing away decades
Hi Sachin,
I am sorry but I am not that familiar with Linux. So you have excuse me.
I can't figure out how to do this. I looked for it in the package manager
and googled it but no luck.
What commands should I run to install and run it?
Thanks in advance / Jennifer
Hi all,
On Thu, 2009-07-30 at 11:02 +0200, Greg Stark wrote:
> On Thu, Jul 30, 2009 at 7:43 AM, Craig
> Ringer wrote:
> > On Wed, 2009-07-29 at 14:56 +0100, Greg Stark wrote:
> > What does work well is occasionally poking the socket with recv(...,
> > MSG_DONTWAIT) while doing other work. Program
i am using a friends account btw...
Thomas Kellerer wrote:
> is there a reason why pg_stat_activity is not documented in
> the chapter "System Catalogs"?
>
> Is this not a "offical" view?
I guess it is because they are documented in
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
in Ch
On Thu, 2009-07-30 at 11:41 +0200, Greg Stark wrote:
> I know this is a popular feeling. But you're throwing away decades of
> work in making TCP reliable. You would change feelings quickly if you
> ever faced this scenario too. All it takes is some bad memory or a bad
> wire and you would be turni
Albe Laurenz, 30.07.2009 11:55:
is there a reason why pg_stat_activity is not documented in
the chapter "System Catalogs"?
I guess it is because they are documented in
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
in Chapter 26.
Maybe a remark in
On Thu, Jul 30, 2009 at 10:59 AM, Csaba Nagy wrote:
> But if I get bad memory or bad wire I'll get much worse problems
> already, and don't tell me it will work more reliably if you don't kill
> the connection. It's a lot better to find out sooner that you have those
> problems and fix them than ha
On 2009-07-28, Jennifer Trey wrote:
> --001636c5a2d8cdcb9c046fc47cee
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi,
> I have been running PostgreSQL 8.3 for a while now and was installed through
> the standard Windows installer and everything has been work
Hi. I need to know what is wrong with this function
[code]
CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
varchar, "pID_EMPREGADO" varchar, "pNOME" varchar, "pNOME_ABREV" varchar,
"pDAT_NASC" date, "pLOCALIDADE_NASC" varchar,
"pID_TIPO_BILHETE_IDENTIFICACAO" varchar, "pB
Greg Stark wrote:
Right, you'll only get SIGURG if there's actually any urgent data
received. The client would have to actively send such data
periodically. That would make this a portability headache since it
wouldn't just be an add-on which would fail gracefully if it's
unsupported.
It'd als
Csaba Nagy wrote:
On Thu, 2009-07-30 at 11:41 +0200, Greg Stark wrote:
I know this is a popular feeling. But you're throwing away decades of
work in making TCP reliable. You would change feelings quickly if you
ever faced this scenario too. All it takes is some bad memory or a bad
wire and you w
On Thu, 2009-07-30 at 13:22 +0200, Craig Ringer wrote:
> So, barring network breaks (wifi down / out of range, ethernet cable
> fell out, etc etc) how is the OP managing to leave backends running
> queries? Hard-resetting the machine?
It happened to us when a client box went out of memory and st
We installed 8.3.7 on a new server. Some of the config changes such as
tracker_acvitity etc are nice.
But big problem. When I start SVN on this machine (which we need!) I
see this error:
-
svn: error while loading shared libraries: libpq.so.4: cannot open
shared object file: No such file or
Hello
don't use COMMIT in plpgsql. Plpgsql doesn't support it.
regards
Pavel Stehule
2009/7/30 Andre Lopes :
> Hi. I need to know what is wrong with this function
>
> [code]
> CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
> varchar, "pID_EMPREGADO" varchar, "pNOME" va
On Thu, Jul 30, 2009 at 12:14 PM, Richard Huxton wrote:
> Dotan Barak wrote:
>>
>> grep on what?
>> (on ps: there isn't anything).
>
> I was thinking of something like:
> # find /etc -type f -print0 | xargs -0 grep 17583
Thanks for clearing this point; Empty string was found.
Dotan
--
Sent via
Csaba Nagy wrote:
> A simple ping to the client would have
cleared the fact that the client is not there anymore.
Yep. It'd also stop PostgreSQL working for clients with software
firewalls, since most of them drop ICMP ECHO ("ping").
TCP keepalives are designed to do the same thing, but do
On 29 Jul 2009, at 14:43, mzh...@ilww.com wrote:
Hello,
In our customer site, the following error occurred. I tried to find
some
indication what this means. Is this log file used for the roll back
purpose? In what scenario that one gets such fatal error?
It's likely part of the WAL, in whi
Csaba Nagy wrote:
It happened to us when a client box went out of memory and started
swapping up to the point it was unaccessible even for console login. The
connections of that machine were still live but unusable, as the client
box will never get out of that state until hard resetting... which
I use a Mac OSX at work. And finally have a running PG install.
So I'm thinking: can I use some mechanism to have my local PG server
(in our premises) as a slave mirror of the main live website server
(at our data center).
Would Slony be the solution to look at? Is this a dumb thought to
begin wi
On 07/30/2009 03:19 PM, Moe wrote:
Hi Sachin,
I am sorry but I am not that familiar with Linux. So you have excuse me.
I can't figure out how to do this. I looked for it in the package
manager and googled it but no luck.
What commands should I run to install and run it?
Thanks in advance / J
On Thu, 2009-07-30 at 13:40 +0200, Craig Ringer wrote:
> > A simple ping to the client would have
> > cleared the fact that the client is not there anymore.
>
> Yep. It'd also stop PostgreSQL working for clients with software
> firewalls, since most of them drop ICMP ECHO ("ping").
I wasn't mea
[just to make things clear, I'm not the one who brought up this
discussion, only that I was also bitten once by zombie connections]
On Thu, 2009-07-30 at 13:29 +0200, Craig Ringer wrote:
> Idle? I thought your issue was _active_ queries running, servicing
> requests from clients that'd since cea
On Thu, Jul 30, 2009 at 12:22 PM, Craig
Ringer wrote:
>
> In fact, I'm not even sure _how_ one goes about exiting without sending an
> RST. A quick check shows that when I `kill -9' a process with an open client
> socket (ssh, in this case) the OS sends a FIN, and responds to the server's
> FIN,ACK
[this is getting off topic]
On Thu, 2009-07-30 at 13:44 +0200, Craig Ringer wrote:
> A host with a runaway process hogging memory shouldn't be dying. It
> should really be killing off the problem process, or the problem process
> should be dying its self after failing to allocate requested memor
On Thu, Jul 30, 2009 at 7:47 AM, Phoenix Kiula wrote:
> I use a Mac OSX at work. And finally have a running PG install.
>
> So I'm thinking: can I use some mechanism to have my local PG server
> (in our premises) as a slave mirror of the main live website server
> (at our data center).
>
>
> Woul
Is there possible to create pg trigger that runs shell script?
--
www.publicstream.cz - vytvořili jsme produkt pro živé přenosy (online
streaming)
a videoarchív ve formátu FLASH.
Bc. Radek Novotný
jednatel Mediawork group s.r.o.
tel.: +420 724 020 361
email: radek.novo...@mediawork.cz
http:/
On Thu, Jul 30, 2009 at 03:09:12PM +0200, Radek Novotnnn wrote:
> Is there possible to create pg trigger that runs shell script?
Yes, pl/perl can do this.
--
Sam http://samason.me.uk/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On Jul 30, 2009, at 9:09 , Radek Novotný wrote:
Is there possible to create pg trigger that runs shell script?
[Please don't top post.]
Yes. You can use an untrusted language such as pl/perlu to run system
commands.
Michael Glaesemann
grzm seespotcode net
--
Sent via pgsql-general m
In response to Radek Novotný :
> Is there possible to create pg trigger that runs shell script?
Sure, use an untrusted language for the trigger-function.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA
On Thu, Jul 30, 2009 at 12:22:03PM +0100, Andre Lopes wrote:
> Hi. I need to know what is wrong with this function
>
> CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
> varchar, "pID_EMPREGADO" varchar, "pNOME" varchar, "pNOME_ABREV" varchar,
[..]
> VALUES ( pID_SOCIEDAD
On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead wrote:
...snip...
> It may make more sense to setup a dedicated PITR slave in your office, and
> refresh it every now and then.
>
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
Thanks. This was useful. So much for my bra
Although mysqldump is the official solution, there's a fabulous perl
script "mysqlhotcopy" that simply copies the data from MySQL tables in
folders and restoring the data is as simple as copying the files back
to their /var/lib/mysql/data location.
I know about pg_dumpall, which creates a humongou
you can always try to write something on your own, using pitr and
pg_start_backup(), rsync, and friends.
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Hi.
I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
I opened the posgres SQL to accept incoming connections:
listen_addresses = '*'
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port
Unfortunately I used the apt-get utility. So I might have missed out on
those packages. But I un-installed (I hope I got everything) and deleted
some folders, got the one click installer and re-installed. I got everything
now and set up postgre and it is working fine. However (something I ran
int
Michael Glaesemann writes:
> On Jul 30, 2009, at 9:09 , Radek Novotný wrote:
>> Is there possible to create pg trigger that runs shell script?
> Yes. You can use an untrusted language such as pl/perlu to run system
> commands.
The fact that you can do it doesn't make it a good idea ...
If you
Craig Ringer writes:
> Greg Stark wrote:
>> Also it requires the server to
>> periodically take time out from processing the query to do this.
> This aspect I'm not to bothered about. I doubt it'd cost anything
> detectable if done a few times a minute - unless it required
> restructuring of qu
> I know about pg_dumpall, which creates a humongous SQL file, but is
> there something equivalent in the postgresql world, like a
> "pgsqlhotcopy" which copies data folders in a similar way as
> mysqlhotcopy?
If you're lucky enough to be using a filesystem which supports atomic
snapshotting of di
On Thu, Jul 30, 2009 at 3:20 PM, Tom Lane wrote:
>
> The earlier part of the discussion was focused on getting the kernel
> to actively tell us when the connection had dropped. That would be
> workable if we found a way to request it, but I think we'd run out of
> options :-(
Yeah, everything I'v
Dotan Barak writes:
> I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
Are you using the Red Hat/CentOS postgresql RPMs, or some other
distribution of PG?
> It seems that the posgres SQL sometimes listen on other ports than 5432:
> # lsof -i -n -P | grep postg
> postmaste 18415 postgres3
Hi,
First I installed postgres using the apt-get utility on ubuntu, and then
later uninstalled it to install postgres though the one-click installer.
Trying to find the share folder i ran pg_config and it shows the old path
: /usr/share/postgresql/8.3
I have a pg_config under my new installation
On Thu, Jul 30, 2009 at 7:37 AM, Phoenix Kiula wrote:
> We installed 8.3.7 on a new server. Some of the config changes such as
> tracker_acvitity etc are nice.
>
> But big problem. When I start SVN on this machine (which we need!) I
> see this error:
>
>
> -
> svn: error while loading shared li
On Thu, Jul 30, 2009 at 5:33 PM, Tom Lane wrote:
> Dotan Barak writes:
>> I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
>
> Are you using the Red Hat/CentOS postgresql RPMs, or some other
> distribution of PG?
Yes, I'm using the original RPM that comes with CentOS.
>
>> It seems that the po
>> I trying to compile several contribs in Osol. I had in result some
>> problems to take them work.
>>
>> /opt/SUNWspro/bin/cc -Xa -xO3 -xarch=native -xspace -W0,-Lt
>> -W2,-Rcond_elim -Xa -xildoff -xc99=none -xCC -KPIC -I.
>> -I../../src/include -c -o xpath.o xpath.c
>> Putting child 0x080a3290
Dotan Barak writes:
> The weird thing is that i used this port in a service that i wrote
> only few seconds before this happened...
Oh? How'd you start that service exactly?
I'm thinking maybe the postmaster inherited the open file from its
parent process. If it's not marked close-on-exec, whi
On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula wrote:
> On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead
> wrote:
>
> ...snip...
>
> > It may make more sense to setup a dedicated PITR slave in your office,
> and
> > refresh it every now and then.
> >
> > http://www.postgresql.org/docs/8.3/interactive
Just another try on TuningWizard.
I tried running it from console :
r...@ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard#
./TuningWizard
./TuningWizard: error while loading shared libraries: libexpat.so.0: cannot
open shared object file: No such file or directory
And :
r..
Hi,
I'am new to PostGre... I need to insert to a view. For security measures the
users will be only able to insert to views.
How can I do that? INSERT INTO a view in PostGreSQL
Best Regards,
André.
In response to Andre Lopes :
> Hi,
>
> I'am new to PostGre... I need to insert to a view. For security measures the
> users will be only able to insert to views.
>
> How can I do that? INSERT INTO a view in PostGreSQL
You have to create a rule.
http://www.postgresql.org/docs/8.3/static/rules-
On Thu, 2009-07-30 at 20:37 +0100, Andre Lopes wrote:
> I'am new to PostGre... I need to insert to a view. For security
> measures the users will be only able to insert to views.
Take a look at the rules system:
http://www.postgresql.org/docs/8.4/static/rules.html
Regards,
Jeff Davis
-
export
LD_LIBRARY_PATH=/opt/PostgreSQL/EnterpriseDB-TuningWizard/lib:$LD_LIBRARY_PATH
or
LD_LIBRARY_PATH=/opt/PostgreSQL/EnterpriseDB-TuningWizard/lib:$LD_LIBRARY_PATH
/opt/PostgreSQL/EnterpriseDB-TuningWizard/TuningWizard
Basically you have to set the LD_LIBRARY_PATH.
This will solve the
phoenix.ki...@gmail.com (Phoenix Kiula) writes:
> My question: how can I use PostgreSQL 8.3 and SVN on the same server?
> Has someone figured out how to fix this situation? I'm on CentOS 5 x64
> bit.
RPM has a "--replacefiles" option which might either help or hurt...
I think there's a fair chanc
On 07/30/2009 08:38 PM, Jennifer Trey wrote:
Hi,
First I installed postgres using the apt-get utility on ubuntu, and
then later uninstalled it to install postgres though the one-click
installer.
Trying to find the share folder i ran pg_config and it shows the old
path : /usr/share/postgresq
On 07/30/2009 07:31 PM, Jennifer Trey wrote:
Unfortunately I used the apt-get utility. So I might have missed out
on those packages.
But I un-installed (I hope I got everything) and deleted some folders,
got the one click installer and re-installed. I got everything now and
set up postgre and
Thank you for your answer.
I did export the LD_LIBRARY_PATH and now the complain is something else..
progress :)
Error: Unable to initialize gtk, is DISPLAY set properly?
I have also launched the TuningWizard from an icon and I got to the step
(development, mixed, dedicated) as before and then th
On Thu, Jul 30, 2009 at 11:02 AM, Vick Khera wrote:
> On Thu, Jul 30, 2009 at 7:37 AM, Phoenix Kiula
> wrote:
> > We installed 8.3.7 on a new server. Some of the config changes such as
> > tracker_acvitity etc are nice.
> >
> > But big problem. When I start SVN on this machine (which we need!) I
Yes, you are right. I didn't stop the server before un-installing. Not good.
I should have thought about that. Not sure how to repair that though.
running pg_config :
r...@ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard#
pg_config
BINDIR = /usr/lib/postgresql/8.3/bin
DOCDIR
On Thu, 2009-07-30 at 19:37 +0800, Phoenix Kiula wrote:
>
> My question: how can I use PostgreSQL 8.3 and SVN on the same server?
> Has someone figured out how to fix this situation?
http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-x86_64/repoview/compat-postgresql-libs.html
Download and install both
Hi,
I'm running 8.4 and I've tried to disable autovacuum since the vacuuming is
taken care internally in the code. The same was true with the previous
version (8.0 to 8.3) and there was never any problem. However now in 8.4 the
"off" setting seems to be ignored even if "track_counts = off" and hug
On Thu, Jul 30, 2009 at 2:52 PM, Costin Grigoras wrote:
> Hi,
>
> I'm running 8.4 and I've tried to disable autovacuum since the vacuuming is
> taken care internally in the code. The same was true with the previous
> version (8.0 to 8.3) and there was never any problem. However now in 8.4 the
> "of
Jennifer Trey wrote:
> >> locate pg_config
> /opt/PostgreSQL/8.4/bin/pg_config
> /opt/PostgreSQL/8.4/include/ecpg_config.h
> /opt/PostgreSQL/8.4/include/pg_config.h
> /opt/PostgreSQL/8.4/include/pg_config_manual.h
> /opt/PostgreSQL/8.4/include/pg_config_os.h
> /opt/PostgreSQL/8.4/include/p
I'm trying to install 8.3.7, but can't get past make check.
CentOS release 4.7 (Final), with an existing install of 8.3.1 running as
a warm standby
$ eval ./configure `pg_config --configure`
$ gmake
== All of PostgreSQL successfully made. Ready to install.
$ gmake check
Everything looks ok un
On Thu, 30 Jul 2009, Phoenix Kiula wrote:
svn: error while loading shared libraries: libpq.so.4: cannot open
shared object file: No such file or directory
I'll bet you installed an RPM at some point with "--force" when you
shouldn't have when installing the new PostgreSQL versions. The packa
The insertion rate is ~250 records / second, quite uniformly spread in
time over ~3000 tables. To reach 2^31 something like 100 days are needed
and the cluster is less than 10 days old. And we do vacuuming :) So as
far as I understand, the wraparound shouldn't happen. In fact before 8.4
we ran
Hi Gurus,
My Client gave me data in .dat format for each table,
which is in postgresql in linux environment
I want to table data in windows environment
Thanks in Advance,
Ramu
Rama Mohan Reddy wrote:
Hi Gurus,
My Client gave me data in .dat format for each table,
which is in postgresql in linux environment
I want to table data in windows environment
I'd suggest taking a look at those .dat files, see if they are in fact
CSV or SQL or what. for instance, in a CM
On Thu, Jul 30, 2009 at 10:56 PM, Costin Grigoras wrote:
> The insertion rate is ~250 records / second, quite uniformly spread in time
> over ~3000 tables. To reach 2^31 something like 100 days are needed and the
> cluster is less than 10 days old. And we do vacuuming :)
I do believe there are som
I read here in a different context
http://www.redhat.com/docs/manuals/cms/rhea-dpg-cms-en-6.1/ch-config.html
About /etc/security/limits.conf and /etc/sysctl.conf files.
For the last year or so I've had this on a CentOS 32 bit system with
4GB of RAM and SATA II disks, only Postgres relevant stuff
Christine Desmuke writes:
> I'm trying to install 8.3.7, but can't get past make check.
> CentOS release 4.7 (Final), with an existing install of 8.3.1 running as
> a warm standby
> ...
> It looks in every case like the ERROR (and also HINT lines) lines are
> causing the failures, but I'm not su
Anytime autovacuum is instrusive look at incrementing the nap time to
10 to 20 ms. If that doesn't help then you're already running on the
ragged edge of IO throughput and might need to look into a faster RAID
array or something.
=> show autovacuum_naptime;
autovacuum_naptime
--
On Fri, Jul 31, 2009 at 12:24 AM, Costin Grigoras wrote:
>
>> Anytime autovacuum is instrusive look at incrementing the nap time to
>> 10 to 20 ms. If that doesn't help then you're already running on the
>> ragged edge of IO throughput and might need to look into a faster RAID
>> array or somethin
On Fri, Jul 31, 2009 at 12:24 AM, Costin Grigoras wrote:
> => show autovacuum;
> autovacuum
>
> off
>
> I really overdid it, I know, but this issue is very annoying. Even with
> these settings it's still ongoing.
>
> The IO doesn't seem to be an issue, the DB sits on a RAID6 of 8 10K
82 matches
Mail list logo
