Re: [GENERAL] Procedural Languages

On 05/31/2012 10:36 PM, John Townsend wrote: There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. Which ones do you use and why? PL/PgSQL, and I avoid using anything else if at all poss

Re: [GENERAL] acessibility for tables

the error sounds clear enough. you should make a very simple test case that shows your problem (including some test data). then people on the list can help cheers, WBL On Thu, Jun 7, 2012 at 1:59 AM, Philipp Kraus wrote: > Hello, > > > On 2012-06-06 09:24:16 +0200, Albe Laurenz said: > > You c

Re: [GENERAL] Partitioning Advice

> > > Since you are on RHEL 6 I would use ext4 throughout. > Great, I'll look into it. However my research suggested a journalled filesystem is unnecessary for xlogs and I assume ext4 is journalled? > You say you have I/O problems when "stats jobs" run. Can you describe > those jobs > and what t

[GENERAL] Postgres 9.2 beta2 one-click installer on windows

Hi all, Just a note that the 32 and 64-bit installers fail on windows 7 64-bit with the error 'An error occurred executing the Microsoft VC++ runtime installer.'. The beta-1 32-bit installer works OK. - Mark Watson

[GENERAL] Question about load balance

Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load average ? Im looking for something multi master solution. Thanks, Hristo -- Sent via

[GENERAL] Two databases on the same server, looking for idea how to restrict access.

Hello, I have two databases on postgresql in different servers, one main database and one secondary not much important, but the problem is they should use some tables both for reading and writing and the secondary postgresql should not have access to whole database on the main database. Im thin

[GENERAL] Memory Overcommit

Hi All, We've just run into the dreaded "OOM Killer". I see that on Linux >2.6, it's recommended to turn off memory overcommit. I'm trying to understand the implications of doing this. The interweb says this means that forking servers can't make use of "copy on write" semantics. Is this true?

Re: [GENERAL] Memory Overcommit

Andy Chambers writes: > We've just run into the dreaded "OOM Killer". I see that on Linux >> 2.6, it's recommended to turn off memory overcommit. I'm trying to > understand the implications of doing this. The interweb says this > means that forking servers can't make use of "copy on write" > se

Re: [GENERAL] Two databases on the same server, looking for idea how to restrict access.

On 07/06/2012 15:39, Condor wrote: > Hello, > > I have two databases on postgresql in different servers, one main > database and one secondary not much important, > but the problem is they should use some tables both for reading and > writing and the secondary postgresql should not > have access t

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

Hi Adrian, Thanks for the suggestion! We thought about that too, but concerned about the possible performance penalty trigger based replication would bring. If there is no other alternative, we will give your suggestion a try... Cheers, Benson - Original Message - From: "Adrian Klaver

[GENERAL] Missing row after update

Hi there. I am new to Postgresql but very familiar with RDBMS. We are running 8.4 on windows serer 2008 r2. I was updating a record through pgAdmin and was being an a$$ and pressed the run button multiple times and then the record just disappeared. Update query: update jaas_login set password=md5(

Re: [GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

Hi, The encoding that is used by the clients that supplied data to the database is ISO-8859-1. Kind Regards, Manoj Agarwal -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Wednesday, June 06, 2012 6:43 PM To: Manoj Agarwal Cc: pgsql-general@postgresql.org Su

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

Hi Josh, Thanks for your prompt reply! Yes, you were right about the parameter. We have upgraded a few times in the past. It was not so painful, as our data as rather small. As our business grows, it becomes harder and harder to do any upgrade that requires downtime. There is never a good time

Re: [GENERAL] Missing row after update

On 06/07/2012 06:57 AM, Dinsdale wrote: > Hi there. I am new to Postgresql but very familiar with RDBMS. We are > running 8.4 on windows serer 2008 r2. I was updating a record through > pgAdmin and was being an a$$ and pressed the run button multiple times > and then the record just disappeared. U

Re: [GENERAL] Missing row after update

On 06/07/2012 06:57 AM, Dinsdale wrote: Hi there. I am new to Postgresql but very familiar with RDBMS. We are running 8.4 on windows serer 2008 r2. I was updating a record through pgAdmin and was being an a$$ and pressed the run button multiple times and then the record just disappeared. Update q

Re: [GENERAL] Partitioning Advice

On 06/06/2012 01:07 AM, Ben Carbery wrote: The new server has a great deal more memory which I am hoping will help (shared_buffers = 8GB, total RAM 20GB), but I am looking at what might be optimal for the storage configuration. From looking at previous conversations here I am thinking of someth

[GENERAL] Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!

hi I just upgraded test copy of database of our customer (~ 600GB of data). upgrade went fine, no errors. but vacuumdb -azv ended with an error: => vacuumdb --all --analyze -p 6665 vacuumdb: vacuuming database "client_db" vacuumdb: vacuuming database "pg_audit" vacuumdb: vacuuming database "postgr

Re: [GENERAL] Counting # of consecutive rows with specified value(s)?

Le 2012-06-06 à 22:20, Ken Tanzer a écrit : > > I can currently test whether someone has at least a specified number of > consecutive absences with the query below, but it would be better to get the > actual number. > > As a second question, what about getting the number of consecutive record

Re: [GENERAL] Missing row after update

On Jun 7, 12:44 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: > On 06/07/2012 06:57 AM, Dinsdale wrote: >  > Hi there. I am new to Postgresql but very familiar with RDBMS. We are >  > running 8.4 on windows serer 2008 r2. I was updating a record through >  > pgAdmin and was being an a$$ and pr

Re: [GENERAL] Missing row after update

On 06/07/2012 11:23 AM, Dinsdale wrote: On Jun 7, 12:44 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: On 06/07/2012 06:57 AM, Dinsdale wrote: > Hi there. I am new to Postgresql but very familiar with RDBMS. We are > running 8.4 on windows serer 2008 r2. I was updating a record through

Re: [GENERAL] pg_database_size differs from df -s

Le mercredi 06 juin 2012 à 21:45 +0200, Frank Lanitz a écrit : > On Wed, 6 Jun 2012 20:31:36 +0200 > Alban Hertroys wrote: > > > On 6 Jun 2012, at 16:33, Frank Lanitz wrote: > > > > > > Is your du reporting sizes in Bytes or blocks or ...? > > Should be byte as its a linux. > Not sure abou

Re: [GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

On 06/06/2012 08:30 PM, Manoj Agarwal wrote: Hi, The encoding that is used by the clients that supplied data to the database is ISO-8859-1. You said previously that you had 29 tables in the 7.4 database and three of those had errors when upgrading to the 8.4 database. At what state is the 8.

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

On 06/07/2012 08:29 AM, Benson Jin wrote: Hi Adrian, Thanks for the suggestion! We thought about that too, but concerned about the possible performance penalty trigger based replication would bring. If there is no other alternative, we will give your suggestion a try... AFAIK there is no dir

Re: [GENERAL] acessibility for tables

Hi, I have recreated the view and the trigger function, now it works. I don't know why it does not run on my first try. My functions shows now: BEGIN IF TG_OP = 'INSERT' then insert into mytargettable values NEW; ELSIF TG_OP = 'UPDATE' then raise notice 'UPDATE trigger, OLD

Re: [GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

On 06/06/2012 08:30 PM, Manoj Agarwal wrote: Hi, The encoding that is used by the clients that supplied data to the database is ISO-8859-1. I meant to ask in my previous post: 1) What are the special characters causing the problem? 2) What is the data type for the fields holding these charac

Re: [GENERAL] Procedural Languages

Will someone please point me to a URL re PG's Java backend cost.. been googling but no joy so far.. I'd like find out how often the JVM starts up eg based on queries or sessions or connections or what... didn't know it was potentially woeful. In particular re "Because Pg doesn't re-use backends, t

Re: [GENERAL] Procedural Languages

Found key info here: http://wiki.tada.se/index.php?title=The_choice_of_JNI Rgds Zenaan On 6/8/12, Zenaan Harkness wrote: > Will someone please point me to a URL re PG's Java backend cost.. been > googling but no joy so far.. > > I'd like find out how often the JVM starts up eg based on queries o

Re: [GENERAL] Two databases on the same server, looking for idea how to restrict access.

Raymond O'Donnell wrote: On 07/06/2012 15:39, Condor wrote: I have two databases on postgresql in different servers, one main database and one secondary not much important, but the problem is they should use some tables both for reading and writing and the secondary postgresql should not have ac

Re: [GENERAL] Missing row after update

On Jun 7, 2:48 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: > On 06/07/2012 11:23 AM, Dinsdale wrote: > > > > > > > On Jun 7, 12:44 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: > >> On 06/07/2012 06:57 AM, Dinsdale wrote: > >>   >  Hi there. I am new to Postgresql but very familiar with

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

On 06/07/2012 10:00 PM, Marc Watson wrote: Hi all, Just a note that the 32 and 64-bit installers fail on windows 7 64-bit with the error 'An error occurred executing the Microsoft VC++ runtime installer.'. The beta-1 32-bit installer works OK. Well, they fail on your particular Windows 7

Re: [GENERAL] Question about load balance

On 06/07/2012 10:26 PM, Condor wrote: Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load average ? Im looking for something multi master

Re: [GENERAL] Procedural Languages

On 06/08/2012 08:40 AM, Zenaan Harkness wrote: Will someone please point me to a URL re PG's Java backend cost.. been googling but no joy so far.. Benchmark it. It depends on your hardware, your workload, your JVM version, your JVM vendor, your Java configuration, whether you have pljava in you