On 15 Mar 2011, at 3:06, Rajesh Kumar Mallah wrote:
Dear Friends,
While taking online basebackup we ignore tar exit codes of 1 .
However under certain circumstances tar exits we code '2' which
stands for 'Fatal Errors' . Eg in case of Cannot stat: No such file or
directory
encountered
On 15 Mar 2011, at 7:46, Alban Hertroys wrote:
On 15 Mar 2011, at 3:06, Rajesh Kumar Mallah wrote:
Dear Friends,
While taking online basebackup we ignore tar exit codes of 1 .
However under certain circumstances tar exits we code '2' which
stands for 'Fatal Errors' . Eg in case of
On 03/15/11 12:30 AM, Alban Hertroys wrote:
On 15 Mar 2011, at 7:46, Alban Hertroys wrote:
On 15 Mar 2011, at 3:06, Rajesh Kumar Mallah wrote:
Dear Friends,
While taking online basebackup we ignore tar exit codes of 1 .
However under certain circumstances tar exits we code '2' which
stands
On Tue, Mar 15, 2011 at 12:13:21AM -0400, Noah Misch wrote:
What is a typical lifespan for a backend in this system? What sort of
connection pooling are you using, if any?
quite long, but:
we have n (~ 40 i think) web servers. each webserver has it's own
pgbouncer (in session pooling).
Thanks alexander
The on_error_rollback setting was exactly the switch I was looking for, thanks.
However I tried to set this setting via the jdbc driver (connection object) or
jdbc properties, but couldnt find a switch to enable this option.
How can i set this setting from my java app?
Hi,
Who maintains the Slony-version that is accessible from Application
Stack Builder on windows?
Would be nice to get the version (for pg 8.4) updated to Slony 2.0.6...
--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
demo 2011 Tore Halvorsen || +052 0553034554
--
Sent via
On 15/03/2011 11:41, Tore Halvorsen wrote:
Hi,
Who maintains the Slony-version that is accessible from Application
Stack Builder on windows?
Would be nice to get the version (for pg 8.4) updated to Slony 2.0.6...
It's maintained by EnterpriseDB as part of the one-click installers.
Ray.
--
On Tue, Mar 15, 2011 at 12:54 PM, Raymond O'Donnell r...@iol.ie wrote:
On 15/03/2011 11:41, Tore Halvorsen wrote:
Who maintains the Slony-version that is accessible from Application
Stack Builder on windows?
It's maintained by EnterpriseDB as part of the one-click installers.
Ok, I'll post
Hi,
I was using Holdem Manager and Postgres database server until a month ago
when it just stopped. Whatever I did didn't help, incl. a teamviewer session
with one of the HM administrators.
I've already read and done everything about that in FAQ, forums,net etc. and
nothing helps.
Please
Hello everyone
Our system:
Windows Server 2008 R2 Foundation
PostgreSQL 9.0.1 64 bits
Days ago, the following message began to appear in the logs every 50
seconds:
2011-03-15 00:07:06 BRT AVISO: pgstat wait timeout
I searched the mailing lists. but couldn't find any useful information.
hubert depesz lubaczewski dep...@depesz.com writes:
On Tue, Mar 15, 2011 at 12:13:21AM -0400, Noah Misch wrote:
What is a typical lifespan for a backend in this system? What sort of
connection pooling are you using, if any?
quite long, but:
we have n (~ 40 i think) web servers. each
On Tue, Mar 15, 2011 at 10:20:38AM -0400, Tom Lane wrote:
hubert depesz lubaczewski dep...@depesz.com writes:
On Tue, Mar 15, 2011 at 12:13:21AM -0400, Noah Misch wrote:
What is a typical lifespan for a backend in this system? What sort of
connection pooling are you using, if any?
hubert depesz lubaczewski dep...@depesz.com writes:
while I understand it, and will pass this information to client, one
thing bugs me - one the problem happens only sometimes, with relatively
low count of backends?
we saw database running normally with 1200 connections, yet sometimes,
it has
Please help! I am using Windows 7 64, I've also tried with/without
firewalls, opened all local ports... Using Nod32 atm and Spybot that runs
in
the background, when ununstalled (both of them) postgres doesn' t work
too
Hi.
I really don't know what a Holdem Manager is, but have you
On Tuesday, March 15, 2011 5:09:27 am Alphadion wrote:
Hi,
I was using Holdem Manager and Postgres database server until a month ago
when it just stopped. Whatever I did didn't help, incl. a teamviewer
session with one of the HM administrators.
I've already read and done everything about
Hi all,
I am using postgres 9.0 under CentOS 5.5 (Dual Xeon Quad Core @ 2,44 GHz,
64GB RAM, 2TB RAID 5). In my case, postgres is used as a backend for the RDF
store Sesame.
I am trying to store a dataset that consists of approximately 900.000.000
insertions (organized in either 10 tables, or in
On Tue, Mar 15, 2011 at 10:58:52AM -0400, Tom Lane wrote:
hubert depesz lubaczewski dep...@depesz.com writes:
while I understand it, and will pass this information to client, one
thing bugs me - one the problem happens only sometimes, with relatively
low count of backends?
we saw database
test
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I tried to install any of the versions but it always gives that message
Could not connect to the database server, please check port 5432 and
127.0.0.1 or something like that. I've opened a range of ports on my
router's page, and also opened one in my computer through the firewall.
Holdem Manager
On Tue, Mar 15, 2011 at 10:55 AM, Alphadion s_savo...@yahoo.com wrote:
I tried to install any of the versions but it always gives that message
Could not connect to the database server, please check port 5432 and
127.0.0.1 or something like that. I've opened a range of ports on my
router's
On Tuesday, March 15, 2011 8:55:33 am Alphadion wrote:
I tried to install any of the versions but it always gives that message
Could not connect to the database server, please check port 5432 and
127.0.0.1 or something like that. I've opened a range of ports on my
router's page, and also
Quote: Is all of this happening locally or is there a remote component?
I dont know how to define that...
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708753.html
Sent from the PostgreSQL - general
I am ready to conclude that the commercial software, Holdem Manager, is
basically trying to farm out their database support to us. However,
Holdem Manager has extensive help topics about getting Postgres working:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
---
Alphadion wrote:
Quote: Is all of this happening locally or is there a remote
Merlin Moncure-2 wrote:
Check your event viewer application log for interesting details.
Confirm if any postgres processes are running in task manager. Look
and see if postgres services is installed in service control manager,
and if it is not running, try and start it.
My money is on
On Tuesday, March 15, 2011 9:01:50 am Alphadion wrote:
Quote: Is all of this happening locally or is there a remote component?
I dont know how to define that...
Are HM and the database both on the same machine or is the connection happening
over the network?
--
Adrian Klaver
Hi Guys,
I'm trying to allow a remote host on our 10.3.55.X network remote access to
a Postgres Database on the same network.
We're running Solaris 10 with Postgres 83
My postgresql.conf looks like this;
listen_addresses = '*' # what IP address(es) to listen on;
On 03/15/11 8:50 AM, general_lee wrote:
svcadm restart svc:/application/database/postgresql_83:default_64bit
But I get a connection refused if I try and telnet to port 5432 from a
remote host.
firewall?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
The eternal Open Source dilemma. Once it is released into the wild are we
responsible for it? In a
Sorry Alban , For the late update.
Yep John,
I am talking about the tar'ring of pgdatadir only excluding the pg_xlog
dir.
We have set up our full backup system in accordance to the admin guide.
Even the guide puts forward the limitation of tar in producing
distinguishing exit codes.
My doubt
On Mon, Mar 14, 2011 at 9:48 AM, Jo jl.n...@uni-bonn.de wrote:
I set the work_mem to 100MB and the shared buffers are 2 GB
The query plans are long and complex. I send the beginning of the
two plans. Hope this helps to understand the differences.
I assume the join strategy in 8.3 differs from
Adrian Klaver wrote:
On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
The eternal Open Source dilemma. Once it is released into the wild are we
On Tuesday, March 15, 2011 8:50:34 am general_lee wrote:
Hi Guys,
I'm trying to allow a remote host on our 10.3.55.X network remote access to
a Postgres Database on the same network.
We're running Solaris 10 with Postgres 83
My postgresql.conf looks like this;
listen_addresses =
On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian br...@momjian.us wrote:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
I have no particular philosophical objection to helping people using
Holdem Manager -- I'd
On Tuesday, March 15, 2011 9:26:44 am Bruce Momjian wrote:
Adrian Klaver wrote:
On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
The eternal
On 03/15/11 9:26 AM, Bruce Momjian wrote:
I think we should make sure they have checked the vendor help system
first or point them to that.
well, the OP did mention a troubleshooting session with the HM support
folks using teamviewer. if they couldn't fix it, well, I dunno how
we're going
On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian br...@momjian.us wrote:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
I have no particular
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server running on host and accepting
TCP/IP
Hi,
Thanks for the reply.
Nope, not a Firewall problem.
I also get connection refused if I telnet by IP address on the Postgres
server.
I can telnet localhost 5432
But not telnet 5432
Anything else I can try here? I'm not sure my pg_hba.conf is correct, what
do you think?
--
View this
Adrian Klaver adrian.kla...@gmail.com writes:
On Tuesday, March 15, 2011 8:50:34 am general_lee wrote:
But I get a connection refused if I try and telnet to port 5432 from a
remote host.
Is this a connection refused from Postgres or telnet?
Postgres doesn't ever emit an error message spelled
can you post output of netstat -lnp when run on the machine
running postgresql server ?
On Tue, Mar 15, 2011 at 9:54 PM, general_lee tim_stockf...@hotmail.comwrote:
Hi,
Thanks for the reply.
Nope, not a Firewall problem.
I also get connection refused if I telnet by IP address on the
Adrian Klaver wrote:
On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian br...@momjian.us wrote:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
Manos Karpathiotakis m...@di.uoa.gr writes:
Hi all,
I am using postgres 9.0 under CentOS 5.5 (Dual Xeon Quad Core @ 2,44 GHz,
64GB RAM, 2TB RAID 5). In my case, postgres is used as a backend for the RDF
store Sesame.
I am trying to store a dataset that consists of approximately 900.000.000
On 03/15/2011 09:36 AM, general_lee wrote:
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server
On 15/03/2011 16:36, general_lee wrote:
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server
On 03/15/11 10:33 AM, Raymond O'Donnell wrote:
Don't you need to have a host in there? - e.g.
$ psql -h 127.0.0.1 etc
$5 gets you $20, the OP was obfuscating his hosts/IPs.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
I'm trying to allow a remote host on our 10.3.55.X network remote access
to
a Postgres Database on the same network.
We're running Solaris 10 with Postgres 83
My postgresql.conf looks like this;
listen_addresses = '*' # what IP address(es) to listen
on;
To confirm, 10.3.55.182 is the Postgres Server
$ telnet 10.3.55.182 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
$ psql -h 10.3.55.182 -U post_owner -d post_db
Hi,
I've checked IP Filter is disabled...
Also this is Solaris 10 - netstat -lnp is not recognised. Here is netstat
-np without my macs :)
I'm using vnet3 so looks like I'm using the wrong netmask, tried editing
pg_hba.conf to 255.255.255.255 instead but still no joy...
Device IP Address
Depending on whether the vendor or user is expected to install and setup
PostgreSQL the issue is that the vendor should be contacting the list and
asking for help with one of their users/setups as opposed to the end-user
asking directly for help. The end-user shouldn't be expected to have the
-Original Message-
From: Bill Thoen [mailto:bth...@gisnet.com]
Sent: Monday, March 14, 2011 11:31 PM
To: pgsql-general@postgresql.org
Subject: Partitioned Database and Choosing Subtables
I've got a ver 8.4.5 partitioned data base with records
organized by US state, so the
On 03/15/2011 10:37 AM, general_lee wrote:
To confirm, 10.3.55.182 is the Postgres Server
$ telnet 10.3.55.182 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
$ psql -h
On 03/15/11 10:24 AM, general_lee wrote:
Hi,
I've checked IP Filter is disabled...
Also this is Solaris 10 - netstat -lnp is not recognised. Here is netstat
-np without my macs :)
netstat -an
shows listening ports.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Doesn't matter I'l try reinstallin the Windows anyway
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3712964.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via
Hi all!
I received a bug report about problems with identifiers.
If I do the following select:
select 1 as tést
The column name returned contains strange chars.
If I do:
select 'tést' as tést
the select value returned is ok but the column name is not. :(
Is there any configuration I need
Here you go.
Explains why locahost is OK, but how do I get PM to listen on *.5432
Thanks for your help
# netstat -a | grep LISTEN
localhost.5999 *.*0 0 49152 0 LISTEN
*.ssh*.*0 0 49152 0 LISTEN
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
# netstat -a | grep LISTEN
localhost.5999 *.*0 0 49152 0 LISTEN
*.ssh*.*0 0 49152 0 LISTEN
*.telnet
Francisco Figueiredo Jr. franci...@npgsql.org wrote:
Hi all!
I received a bug report about problems with identifiers.
If I do the following select:
select 1 as tést
The column name returned contains strange chars.
If I do:
select 'tést' as tést
the select value returned is
On 15/03/2011 18:14, general_lee wrote:
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
Did you restart Postgres after changing listen_addresses in postgresql.conf?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general
Explains why locahost is OK, but how do I get PM to listen on *.5432
Well, you believe you already have, by telling PostgreSQL to
listen on '*'. There might be a few different reason why it's
not:
1) Are you editing the correct postgresql.conf file? Do you have
multiple ones on the
This is the query our user sent as one of the problems:
select zurück as zurück3_103_ from Tabelle tabellenhib0_
And here is the link to our bug report:
http://pgfoundry.org/tracker/index.php?func=detailaid=1010988group_id=1000140atid=590
I didn't test putting double quotes in the column name
On 03/15/2011 11:14 AM, general_lee wrote:
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
Are you sure you are looking at the correct configuration files? Is it
possible there is more than one set on the machine and the cluster you
are restarting
On 03/15/11 11:26 AM, Raymond O'Donnell wrote:
On 15/03/2011 18:14, general_lee wrote:
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
Did you restart Postgres after changing listen_addresses in
postgresql.conf?
he indicated he did, via 'svcadm
Francisco Figueiredo Jr. franci...@npgsql.org wrote:
What happens if you remove the double quotes in the column name identifier?
the same:
test=*# select 'tést' as tést;
tést
--
tést
(1 Zeile)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
We recently upgraded from 8.3.something to 9.0.1. With 9.0.1, we have a
huge spike in vacuums every 8 days only on one of our DB servers. We go
from approx 20 vacuums every 5 minutes to 350 per 5 minutes. This lasts for
several hours, then stops. I have attached a graph that shows the
H,
What would change the encoding of the identifiers?
Because on my dev machine which unfortunately isn't with me right now
I can't get the identifier returned correctly :(
I remember that it returns:
test=*# select 'tést' as tést;
tst
--
tést
Is there any config I can
Guys,
Thanks for your help.
When I saw that netstat was not listening as *.5432 I decided to;
svcadm disable svc:/application/database/postgresql_83:default_64bit
Then;
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
This fixed the problem.
You guys were right on the money, looks like
On Tuesday, March 15, 2011 1:33:48 pm general_lee wrote:
Guys,
Thanks for your help.
When I saw that netstat was not listening as *.5432 I decided to;
svcadm disable svc:/application/database/postgresql_83:default_64bit
Then;
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
What it probably means is that this:
svc:/application/database/postgresql_83:default_64bit
is pointing at a different instance of Postgres than this:
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
indeed.
# svcprop svc:/application/database/postgresql_83:default_64bit | grep data
Hi All,
Is it a big no-no to enable/disable triggers by manually setting
pg_trigger.tgenabled to 'D'?
--
Andy Chambers
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
I have a table holding number of games per week for each user:
# select id,completed,yw from pref_match limit 3;
id | completed | yw
+---+-
OK2650139676 | 10 | 2011-03
OK513367704098 | 20 | 2011-03
OK513367704098 |
On Tue, Mar 15, 2011 at 05:01:50PM -0400, Andy Chambers wrote:
Is it a big no-no to enable/disable triggers by manually setting
pg_trigger.tgenabled to 'D'?
No, but I seem to recall having seen corner cases where it didn't
work. (This was the reason that in older versions of slony, slony
On Mar 16, 2011, at 2:31 AM, Andy Chambers wrote:
Is it a big no-no to enable/disable triggers by manually setting
pg_trigger.tgenabled to 'D'?
Not recommended to do anything with catalog tables. At the place of this use
following command:
ALTER TABLE tablename DISABLE TRIGGER [
Thank you all for the replies!
On Wed, Mar 9, 2011 at 7:01 PM, David Johnston pol...@yahoo.com wrote:
SELECT username, count(username) FROM phpbb_users
GROUP BY username
HAVING count(username) 1;
If anything shows up then (phpbb_users .username) is not a unique field but
you are trying to
On Mar 16, 2011, at 3:03 AM, Alexander Farber wrote:
# select u.id, u.first_name, sum(m.completed)
from pref_users u, pref_match m
where u.id=m.id and u.id like 'DE%' and
sum 30 group by u.id, u.first_name
order by sum desc limit 3;
ERROR: column sum does not exist
LINE 4: ...f_match
Unfortunately I get:
# select u.id, u.first_name, sum(m.completed) from pref_users u,
pref_match m where u.id=m.id and u.id like 'DE%' and sum(m.completed)
30 group by u.id, u.first_name order by sum desc limit 3;
ERROR: aggregates not allowed in WHERE clause
LINE 1: ...f_match m where
And same for a simple select-query from1 table (w/o join):
# select id from pref_match where sum(completed) 30 group by id;
ERROR: aggregates not allowed in WHERE clause
LINE 1: select id from pref_match where sum(completed) 30 group by...
^
--
Sent
On Mar 16, 2011, at 3:12 AM, Alexander Farber wrote:
Unfortunately I get:
# select u.id, u.first_name, sum(m.completed) from pref_users u,
pref_match m where u.id=m.id and u.id like 'DE%' and sum(m.completed)
30 group by u.id, u.first_name order by sum desc limit 3;
ERROR: aggregates not
On Mar 16, 2011, at 3:15 AM, Alexander Farber wrote:
And same for a simple select-query from1 table (w/o join):
# select id from pref_match where sum(completed) 30 group by id;
ERROR: aggregates not allowed in WHERE clause
LINE 1: select id from pref_match where sum(completed) 30 group
On 3/15/2011 12:02 PM, Igor Neyman wrote:
-Original Message-
From: Bill Thoen [mailto:bth...@gisnet.com]
Sent: Monday, March 14, 2011 11:31 PM
To: pgsql-general@postgresql.org
Subject: Partitioned Database and Choosing Subtables
I've got a ver 8.4.5 partitioned data base with records
Now, I'm using my dev machine.
With the tests I'm doing, I can see the following:
If I use:
select 'seléct' as seléct;
column name returns ok as expected.
If I do:
select 'seléct' as seléct;
This is the sequence of bytes I receive from postgresql:
byte1 - 115 UTF-8 for s
byte2 - 101 UTF-8
Hi All,
In Postgresql we can use savepoint and rollback to savepoint in transaction.
But we cannot use savepoint in function.
Currently I am doing migration from Informix to Postgresql 8.4.
In Informix they used Savepoint.
Please advice how to use Savepoint and rollback to savepoint in function.
I
82 matches
Mail list logo