Hi,
is there a reason why pg_stat_activity is not documented in the chapter System Catalogs?
Is this not a offical view?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
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 into as an alternative
to our existing query cancel method).
On Thu, Jul 30, 2009 at 08:37, Thomas Kellererspam_ea...@gmx.net 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,
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:
snip start from postgresql.conf
listen_addresses = '*'
# comma-separated list of addresses;
# defaults
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:
snip start from postgresql.conf
listen_addresses = '*'
# comma-separated list of addresses;
Magnus Hagander, 30.07.2009 09:24:
On Thu, Jul 30, 2009 at 08:37, Thomas Kellererspam_ea...@gmx.net 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
On Thu, Jul 30, 2009 at 8:41 AM, Tatsuo Ishiiis...@postgresql.org 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
On Thu, Jul 30, 2009 at 7:43 AM, Craig
Ringercr...@postnewspapers.com.au 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
Thanks for the quick response.
On Thu, Jul 30, 2009 at 11:26 AM, Richard Huxtond...@archonet.com 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:
snip start from postgresql.conf
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 Nagyn...@ecircle-ag.com 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
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
Ringercr...@postnewspapers.com.au 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
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 Chapter
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 turning
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 Nagyn...@ecircle-ag.com 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
On 2009-07-28, Jennifer Trey jennifer.t...@gmail.com 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
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,
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
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
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
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 lopes80an...@gmail.com:
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,
On Thu, Jul 30, 2009 at 12:14 PM, Richard Huxtond...@archonet.com 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
--
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 it
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
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...
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
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 /
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 meaning TCP
[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
On Thu, Jul 30, 2009 at 12:22 PM, Craig
Ringercr...@postnewspapers.com.au 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
[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 memory.
On Thu, Jul 30, 2009 at 7:47 AM, Phoenix Kiula phoenix.ki...@gmail.comwrote:
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
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
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
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
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_SOCIEDADE,
You're
On Thu, Jul 30, 2009 at 8:31 PM, Scott Meadscott.li...@enterprisedb.com 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
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 humongous
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:
Hi.
I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
I opened the posgres SQL to accept incoming connections:
snip start from postgresql.conf
listen_addresses = '*'
# comma-separated list of addresses;
# defaults
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
Michael Glaesemann g...@seespotcode.net 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
Craig Ringer cr...@postnewspapers.com.au 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
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
On Thu, Jul 30, 2009 at 3:20 PM, Tom Lanet...@sss.pgh.pa.us 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,
Dotan Barak dota...@gmail.com 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
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 Kiulaphoenix.ki...@gmail.com 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
On Thu, Jul 30, 2009 at 5:33 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Dotan Barak dota...@gmail.com 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
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 (xpath.o)
Dotan Barak dota...@gmail.com 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
On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula phoenix.ki...@gmail.comwrote:
On Thu, Jul 30, 2009 at 8:31 PM, Scott Meadscott.li...@enterprisedb.com
wrote:
...snip...
It may make more sense to setup a dedicated PITR slave in your office,
and
refresh it every now and then.
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 :
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.
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
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 chance
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 :
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
On Thu, Jul 30, 2009 at 11:02 AM, Vick Khera vi...@khera.org wrote:
On Thu, Jul 30, 2009 at 7:37 AM, Phoenix Kiulaphoenix.ki...@gmail.com
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
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
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 of
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 huge
On Thu, Jul 30, 2009 at 2:52 PM, Costin Grigorascost...@gmail.com 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
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
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
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
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
On Thu, Jul 30, 2009 at 10:56 PM, Costin Grigorascost...@gmail.com 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
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
Christine Desmuke cdesm...@kshs.org 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,
81 matches
Mail list logo