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
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
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
--
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
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
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
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
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
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
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
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
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
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
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, 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
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, 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
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 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
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
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
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
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
-
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-
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é.
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..
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
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
>> 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
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
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
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
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
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
> 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
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
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
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
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
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
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
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
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
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 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
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
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 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
[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 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
[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, 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
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
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
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
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:
> 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 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
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
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
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
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
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
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
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
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
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, 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
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
i am using a friends account btw...
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
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
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
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:
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 = '*'
>>
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
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
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
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
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 =
> 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
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
82 matches
Mail list logo
