Re: [GENERAL] 60 Seconds to connected to Postgresql using ODBC or PGAdmin

Richard Broersma Jr wrote: It seems the OP's connection string was set to localhost. Would this still indicate a Name Loopup problem? Do you have some some firewall running ? Also is there a localhost entry in your hosts file(e.g /etc/hosts or C:/windows/system32/drivers/etc) ? Peter -

Re: [GENERAL] 60 Seconds to connected to Postgresql using ODBC or PGAdmin

Richard Broersma Jr wrote: --- On Wed, 11/28/07, Richard Huxton <[EMAIL PROTECTED]> wrote: Name lookups. Something is trying to look up a name, failing and it's timing out after 60 seconds. It seems the OP's connection string was set to localhost. Would this still indicate a Name Loopup pro

Re: [GENERAL] Why upgrade?

Chris -- You asked > > I'm currently using 7.4 and I trying find out what the value/advantage > of upgrading to a more recent version and to which version. > Eventually 7.4 will not be supported (there's discussion elsewhere on how to deal with 7.3), so it would pay to move off of it well befo

Re: [GENERAL] 60 Seconds to connected to Postgresql using ODBC or PGAdmin

Richard Broersma Jr wrote: --- On Wed, 11/28/07, Richard Huxton <[EMAIL PROTECTED]> wrote: Name lookups. Something is trying to look up a name, failing and it's timing out after 60 seconds. It seems the OP's connection string was set to localhost. Would this still indicate a Name Loopup probl

[GENERAL] hibernate + postgresql ?

Hello, any exprerience with Hibernate + PostgreSQL ? How does this combination is flexible and smart ? Is't possible to tune selected queries ? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

[GENERAL] test message

Sorry People, this is a test message as it seems mail I'm writing to this list isn't going through-- I just want to see if I get a rebound of it... Please apologize. -- Pedro Doria Meunier Ips da Olaria Edf. Jardins do Garajau, 4 r/c Y 9125-163 Caniço Madeira Portugal GSM: +351 96 17 20 188 Sky

[GENERAL] viewing definition of "CREATE TYPE name AS ENUM..."

After a type is created, is it possible to view the definition of this type? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Declaring multidimensional arrays in pl/pgsql

Hi, all. I was wondering, can I really declare a 2-dimensional array of arbitrary size in pl/pgsql? According to the docs it seems that only way would be to declare it as something like : myArray := ARRAY[[1,2], [3,4], [5,6]]; But what if I pass the dimensions as function parameters? My po

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Wed, Nov 28, 2007 at 10:33:08AM -0800, Trevor Talbot wrote: > On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > Trevor Talbot wrote: > > > On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > > >> There is at least one other bottleneck, probably more than one. Context > > >> sw

[Re] Re: [Re] Re: [Re] Re: [Re] Re: [GENERAL] Unknown winsock error 10061while dumping a big database

De : mailto:[EMAIL PROTECTED] > Cyril VELTER wrote: > > > > Is length() supposed to return the very high length in case of > > corruption ? > > You'd have thought it would. The odd thing (if it is data corruption) is > that you would expect to see something in the server logs about a > fa

Re: [Re] Re: [Re] Re: [Re] Re: [Re] Re: [GENERAL] Unknown winsock error 10061while dumping a big database

Cyril VELTER wrote: De : mailto:[EMAIL PROTECTED] Cyril VELTER wrote: Is length() supposed to return the very high length in case of corruption ? You'd have thought it would. The odd thing (if it is data corruption) is that you would expect to see something in the server logs about a failur

[GENERAL] Killing a session on windows

I have a database I want to drop on a windows server. Unfortunately I cannot restart postgres because it is running several live database. To kill the offending session, I tried select * from pg_stat_activity to find the PID of the session, and then tried to kill it with command line: taskk

Re: [GENERAL] Killing a session on windows

Howard Cole wrote: I have a database I want to drop on a windows server. Unfortunately I cannot restart postgres because it is running several live database. To kill the offending session, I tried select * from pg_stat_activity to find the PID of the session, and then tried to kill it with c

Re: [GENERAL] Recheck condition

Please always CC the list so other people can respond. On Wed, Nov 28, 2007 at 10:21:39PM -0500, Josh Harrison wrote: > > It isn't the recheck that's costing it, it's probably just that you're > > matching a lot of rows. A bitmap scan classically needs a recheck > > because if a lot of rows need t

Re: [GENERAL] Killing a session on windows

Use "select pg_cancel_backend()" instead -- we have to do this periodically when queries get timed out by the web server but Postgres doesn't notice / doesn't get notified... - Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Cole Sent: Thursda

[GENERAL] 1 cluster on several servers

Hi, Is it possible to run one PostgreSQL cluster on more than one (hardware) server? WBL

Re: [GENERAL] 1 cluster on several servers

Willy-Bas Loos wrote: Hi, Is it possible to run one PostgreSQL cluster on more than one (hardware) server? WBL You would be looking for replication. Start with http://www.postgresql.org/docs/8.2/interactive/high-availability.html to get some idea on what is available for what you wish to achi

Re: [GENERAL] hibernate + postgresql ?

i have experience with Hibernate and postggresql, what information are you exactly looking for? On Nov 29, 2007 1:52 PM, Oleg Bartunov <[EMAIL PROTECTED]> wrote: > Hello, > > any exprerience with Hibernate + PostgreSQL ? How does this combination > is flexible and smart ? Is't possible to tune se

Re: [GENERAL] hibernate + postgresql ?

Oleg Bartunov ha scritto: Hello, any exprerience with Hibernate + PostgreSQL ? How does this combination is flexible and smart ? Is't possible to tune selected queries ? You can evaluate also JPA, openJPA (http://openjpa.apache.org/) seems good but now I have only simple query on it. Edoardo

Re: [GENERAL] Recheck condition

> > > For example if I have a table Person with 3 fields (name,city_id,age). > And > > the table contains 1000 rows. The table has 2 indexes city_id and age > > If I have a query : > > SELECT * FROM PERSON WHERE city_id=5 AND AGE=30 > > The answer is "it depends". Postgres has a cost based planner,

Re: [GENERAL] 1 cluster on several servers

I'll take that as a "no". What i mean is to actually run exactly one cluster (no replicated copy) on more than one server. Of course, if that were possible, why would people bother with replication.. I guess it is irrational to suggest that it would be possible, since each server would at least ne

Re: [GENERAL] Recheck condition

Josh Harrison escribió: > > > > > For example if I have a table Person with 3 fields (name,city_id,age). > > And > > > the table contains 1000 rows. The table has 2 indexes city_id and age > > > If I have a query : > > > SELECT * FROM PERSON WHERE city_id=5 AND AGE=30 > > OkaySo If I have a que

Re: [GENERAL] 1 cluster on several servers

Willy-Bas Loos wrote: Is there an implementation for this in PostgreSQL? It would have to be something like pgPool (middleware), because: How would the query know on which server to put it's data? And i guess i would need some Kerberos-like implementation for my authentication and authorization.

[GENERAL] Slony-I creation scripts not available

>From within pgAdminIII I get this message in the status bar when I go to setup slony-I replication. I have the scripts in pgdir /shared after installing from source, should they be somewhere else, or should I have some environment variables set? Glyn Astill __

Re: [GENERAL] Declaring multidimensional arrays in pl/pgsql

I wrote: > You can declare arbitrary-sized, n-dimensional arrays: Sorry, I re-read your post. You want to programatically define the array dimensions depending on function arguments. You could try building a string, then casting to the correct array type (not tested). --

Re: [GENERAL] Declaring multidimensional arrays in pl/pgsql

On Thu, 29 Nov 2007 18:11:22 +0400, Rodrigo De León <[EMAIL PROTECTED]> wrote: On Nov 29, 2007 3:34 AM, Max Zorloff <[EMAIL PROTECTED]> wrote: According to the docs it seems that only way would be to declare it as something like : myArray := ARRAY[[1,2], [3,4], [5,6]]; You can declare arbit

Re: [GENERAL] Declaring multidimensional arrays in pl/pgsql

On Nov 29, 2007 3:34 AM, Max Zorloff <[EMAIL PROTECTED]> wrote: > According to the docs it seems that only way would be to declare it as > something like : > myArray := ARRAY[[1,2], [3,4], [5,6]]; You can declare arbitrary-sized, n-dimensional arrays: ... DECLARE myArray integer[][]; -- two-dime

Re: [GENERAL] 1 cluster on several servers

Willy-Bas Loos wrote: I'll take that as a "no". What i mean is to actually run exactly one cluster (no replicated copy) on more than one server. Of course, if that were possible, why would people bother with replication.. I guess it is irrational to suggest that it would be possible, since each

Re: [GENERAL] Slony-I creation scripts not available

Hi. From: "Glyn Astill" <[EMAIL PROTECTED]> From within pgAdminIII I get this message in the status bar when I go to setup slony-I replication. I have the scripts in pgdir /shared after installing from source, should they be somewhere else, or should I have some environment variables set? I

[GENERAL] Making a query from 2 tables at same time

Hi everybody I'm doing a two table query as follow mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and t2.idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101')>2; and i get the following error ERROR: schema "t2" does not exist but thos

Re: [GENERAL] Making a query from 2 tables at same time

Pau Marc Munoz Torres wrote: Hi everybody I'm doing a two table query as follow mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and t2.idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101')>2; and i get the following error ERROR: schema

Re: [GENERAL] Slony-I creation scripts not available

Sorry Hiroshi, I failed to understand exactly what you're saying there. So far I've installed Slony as per the docs, all seems to be well and the installer ahs put the replication *.sql files in pgsql/shared. I haven't started the slon daemons yet. I thought once slony was set up you could then

Re: [GENERAL] Making a query from 2 tables at same time

am Thu, dem 29.11.2007, um 15:48:45 +0100 mailte Pau Marc Munoz Torres folgendes: > Hi everybody > > I'm doing a two table query as follow > > mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as > t1, precalc as t2 where t1.ce='ACIAD' and t2.idr(p1, p4, p6, p7, p9, >

Re: [GENERAL] Making a query from 2 tables at same time

i test it and now the error is mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and idr(t2.p1, t2.p4, t2.p6, t2.p7, t2.p9, 'HLA-DRB5*0101')>2; ERROR: relation "pssms" does not exist CONTEXT: SQL statement "SELECT score from PSS

Re: [GENERAL] Slony-I creation scripts not available

Hi. From: "Glyn Astill" <[EMAIL PROTECTED]> Sorry Hiroshi, I failed to understand exactly what you're saying there. Ahh, Sorry... So far I've installed Slony as per the docs, all seems to be well and the installer ahs put the replication *.sql files in pgsql/shared. I haven't started the

[GENERAL] notify/listen disappearing data

select version() "PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)" Today I added 2 new fields to a single row table and populated them with values. I noticed that the values disappeared after a while and

Re: [GENERAL] Declaring multidimensional arrays in pl/pgsql

On Thu, 29 Nov 2007 19:21:03 +0400, Pavel Stehule <[EMAIL PROTECTED]> wrote: Hello arrays in PostgreSQL have to be regular allways. And before 8.3 array cannot contais NULL, so you cannot simpl resize two dim array :(. But your functions doesn't work in 8.3. too. So you can a) use 1D array a

Re: [GENERAL] Making a query from 2 tables at same time

Pau Marc Munoz Torres wrote: i test it and now the error is mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and idr(t2.p1, t2.p4, t2.p6, t2.p7, t2.p9, 'HLA-DRB5*0101')>2; ERROR: relation "pssms" does not exist CONTEXT: SQL st

Re: [GENERAL] hibernate + postgresql ?

Oleg Bartunov wrote: Hello, any exprerience with Hibernate + PostgreSQL ? How does this combination is flexible and smart ? Is't possible to tune selected queries ? In short, it sucks :). Long description: Hibernate is a mature ORM for Java. It is in use with PostgreSQL in quite a few instal

[GENERAL] HD is flooded by Error Log info

Hello Recently an application endless loop crashed the PG server. I am looking for the safest way to limit the growth of the all the files in the "pg_log" directory, While still maintain reasonable period of log. Any suggestions? Our current setup is: #--

Re: [GENERAL] HD is flooded by Error Log info

Hello Recently an application endless loop crashed the PG server. I am looking for the safest way  to limit the growth of the all the files in the “pg_log” directory, While still  maintain reasonable period of log. Any suggestions? Our current setup is: #--

Re: [GENERAL] notify/listen disappearing data

Sim Zacks wrote: select version() "PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)" Upgrade to 8.0.14 - you are missing 13 sets of bugfixes. Today I added 2 new fields to a single row table and popula

Re: [GENERAL] notify/listen disappearing data

"Sim Zacks" <[EMAIL PROTECTED]> writes: > select version() > "PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc > (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)" Several of the bugs listed in the 13 bug-fix releases which follow this one relate to tuple

Re: [GENERAL] hibernate + postgresql ?

i has exactly the same discussion with a bunch of java developers over the use of Hibernate with Postgres, and most of them feel that it gives them the ability to write code and not worry about which backend will be plugged in Oracle or postgres or Mysql and any other, if you are using it with some

Re: [GENERAL] HD is flooded by Error Log info

what i do is setup a cron job which runs daily or every second day, creates a tar.gz and copies them to a seperate location, and then another cron job which clears up archives more than one month old. That seems to be the way to go, i don't think you will find a postgresql.conf parameter which does

Re: [GENERAL] HD is flooded by Error Log info

On Thu, 2007-11-29 at 09:53 -0600, Abraham, Danny wrote: > Recently an application endless loop crashed the PG server. > > I am looking for the safest way to limit the growth of the all the > files in the “pg_log” directory, > > While still maintain reasonable period of log. Sounds like we sh

Re: [GENERAL] Making a query from 2 tables at same time

Ok, I have two tables, first one, that i call precalc has the following structure id . serial p1 varchar p4 varchar p6 varchar p7 varchar p9 varchar and a numer of index that is a real number resulting of a function (function is called idr and i talk about it bellow) another table is loca

Re: [GENERAL] hibernate + postgresql ?

On Thu, 29 Nov 2007, Joshua D. Drake wrote: Oleg Bartunov wrote: Hello, any exprerience with Hibernate + PostgreSQL ? How does this combination is flexible and smart ? Is't possible to tune selected queries ? In short, it sucks :). Long description: Hibernate is a mature ORM for Java. It is

Re: [GENERAL] viewing definition of "CREATE TYPE name AS ENUM..."

There is no direct system information function like pg_get_indexdef etc, but you can find the enum labels in pg_enum catalog table, and there are some enum support functions See if they help you http://www.postgresql.org/docs/8.3/static/functions-enum.html On Nov 29, 2007 1:53 PM, Richard Broersm

Re: [GENERAL] HD is flooded by Error Log info

On Thu, Nov 29, 2007 at 04:20:30PM +, Simon Riggs wrote: > > - pg_log file archiving when we reach a certain volume/number of logs IMO, by the time we get that complicated, admins need to start doing some work. That is, I think, work that should be nowhere near the main PostgreSQL code. If

Re: [GENERAL] Making a query from 2 tables at same time

This is the problem: > ... t2.idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101')>2; What is that t2.idr ? Based on the syntax postgres must look for a function (because of the parentheses), and it thinks t2 is the schema where it must look for it. Cheers, Csaba. ---(end of broad

[GENERAL] Problems Dumping DB

Hello Everyone, We a have a DB running on PostgreSQL 8.0.12 that has been running into a string of issues and as of now we have ran out solutions, so we would like to hear some input from some more knowledgeable people. Initially we found out that our DB had the xid-wrap problem. Given so

Re: [GENERAL] HD is flooded by Error Log info

As far as automatic archiving is concerned the easiest would be to provide something similar to "archive_command" , however i can't imagine how the second suggestion could be useful, that sounds like pretty dangerous to me. On Nov 29, 2007 9:20 PM, Simon Riggs <[EMAIL PROTECTED]> wrote: > On T

Re: [GENERAL] Making a query from 2 tables at same time

Pau Marc Munoz Torres wrote: Ok, I have two tables, first one, that i call precalc has the following structure ... and a numer of index that is a real number resulting of a function (function is called idr and i talk about it bellow) ... another table is local than has the following fields

Re: [GENERAL] HD is flooded by Error Log info

Andrew Sullivan wrote: On Thu, Nov 29, 2007 at 04:20:30PM +, Simon Riggs wrote: - pg_log file archiving when we reach a certain volume/number of logs IMO, by the time we get that complicated, admins need to start doing some work. That is, I think, work that should be nowhere near the main

[GENERAL] Will PG use composite index to enforce foreign keys?

Hi - I know that the foreign key machinery will use an index on the referring column if one exists. My question is whether it will use a composite index? For instance: create table allLemmaSenseMap ( wordID integer references allLemmas, senseIDinteger references allSenses, p

Re: [GENERAL] 1 cluster on several servers

On Nov 29, 2007 6:27 PM, Willy-Bas Loos <[EMAIL PROTECTED]> wrote: > I'll take that as a "no". > What i mean is to actually run exactly one cluster (no replicated copy) on > more than one server. Of course, if that were possible, why would people > bother with replication.. > > I guess it is irrat

Re: [GENERAL] HD is flooded by Error Log info

On Thu, Nov 29, 2007 at 04:50:45PM +, Richard Huxton wrote: > Surely this is what logrotate and syslog-ng etc are for. This is a > sysadmin problem not a DBA problem - any service can generate a lot of logs. Yes. But some have complained those things aren't Postgres-centric enough. I don't s

Re: [GENERAL] HD is flooded by Error Log info

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 29 Nov 2007 11:58:36 -0500 Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Thu, Nov 29, 2007 at 04:50:45PM +, Richard Huxton wrote: > > Surely this is what logrotate and syslog-ng etc are for. This is a > > sysadmin problem not a DBA prob

[GENERAL] Discrpency in the GRANT docs

I just noticed this. In the section of the page, near the end, that describes the access privileges display generated by psql's \z (which come from pg_class.relacl) there is the following: / -- user who granted this privilege That's not the case. What get's listed there is the current

Re: [GENERAL] viewing definition of "CREATE TYPE name AS ENUM..."

--- On Thu, 11/29/07, Usama Dar <[EMAIL PROTECTED]> wrote: > See if they help you > http://www.postgresql.org/docs/8.3/static/functions-enum.html I will give this a try, thanks! Regards, Richard Broersma Jr. ---(end of broadcast)--- TIP 5: don't

Re: [GENERAL] Declaring multidimensional arrays in pl/pgsql

On Thu, 29 Nov 2007 21:15:50 +0400, Rodrigo De León <[EMAIL PROTECTED]> wrote: On Nov 29, 2007 9:33 AM, Max Zorloff <[EMAIL PROTECTED]> wrote: I don't think that works. ponline=# select ('{1,2,3}'::text)::int[]; ERROR: cannot cast type text to integer[] Can you try: select ('{1,2,3}'::un

Re: [GENERAL] Error compiling Slony I

On Nov 28, 2007, at 11:17 AM, Glyn Astill wrote: I've already tried removing and re-installing bison, but I shall try again as you suggest. I recommended uninstalling bison, not re-installing it. ---(end of broadcast)--- TIP 6: explain analyz

Re: [GENERAL] HD is flooded by Error Log info

Andrew Sullivan <[EMAIL PROTECTED]> writes: > The general tone in this thread sounds like, "I don't have time to > administer this; help me." Providing such help is a bad idea. Actually, can't it be solved easily enough with suitable configuration of the existing logging parameters? Just set th

Re: [GENERAL] Discrpency in the GRANT docs

Erik Jones <[EMAIL PROTECTED]> writes: > I just noticed this. In the section of the page, near the end, that > describes the access privileges display generated by psql's \z (which > come from pg_class.relacl) there is the following: > / -- user who granted this privilege > That's not th

[GENERAL] ERROR: failed to find conversion function from unknown to integer[]

t=# select version(); version PostgreSQL 8.3beta3, compiled by Visual C++ build 1400 (1 row) t=# -- foo is of type unknown t=# select '{1,2,3}' as foo; foo - {1,2,3} (1 row) t=# -- OK. foo is of type int

Re: [GENERAL] Discrpency in the GRANT docs

On Nov 29, 2007, at 12:05 PM, Tom Lane wrote: Erik Jones <[EMAIL PROTECTED]> writes: I just noticed this. In the section of the page, near the end, that describes the access privileges display generated by psql's \z (which come from pg_class.relacl) there is the following: / -- user wh

Re: [GENERAL] PostgresSQL vs. Informix

On Wed, Nov 28, 2007 at 11:11:07PM -0700, Gregory Williamson wrote: > * There is no equivalent of a "synonym"; a view can be used to fake this > sometimes > but where Informix lets you create a synonym to a table in another > database / > instance, PostgreSQL doesn't. dblink can be use

[GENERAL] Dump/Restore Large Object OID

Hi all If I don't use the --oids option when dumping a database with pg_dump, can I assure that the "loid" field of the pg_largeobject table will keep it's value when restoring? Thanks in advance Norberto ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] HD is flooded by Error Log info

On Thu, Nov 29, 2007 at 12:48:35PM -0500, Tom Lane wrote: > Andrew Sullivan <[EMAIL PROTECTED]> writes: > > The general tone in this thread sounds like, "I don't have time to > > administer this; help me." Providing such help is a bad idea. > > Actually, can't it be solved easily enough with sui

Re: [GENERAL] PostgresSQL vs. Informix

On Nov 28, 2007, at 6:11 PM, Jeff Larsen wrote: I can't offer much in the way of a case study, but I am an Informix customer that has been doing an informal feasibility study on switching to PostgreSQL. I've learned a ton from the high quality PG docs and from the PG mailing lists. I switched a

[GENERAL] problems with email...

Hi. I seem to have *extreme* problems sending messages to this list... :-( Could one of the people responsible for the list see if anything is wrong with my account, please? Thanks! -- Pedro Doria Meunier Ips da Olaria Edf. Jardins do Garajau, 4 r/c Y 9125-163 Caniço Madeira Portugal GSM: +351 9

[GENERAL] free ETL using Postgresql 8.2.x

Dear all, I've released a graphical and simple ETL tool using Postgresql under Windows. Is working with .txt or .csv files. It is called "Benetl" and you can find (and freely download) it at : www.benetl.net This is a first version, your comments are welcomed, there is a forum you can use it to r

Re: [GENERAL] hibernate + postgresql ?

Begin forwarded message: On Nov 29, 2007 8:52 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Oleg Bartunov wrote: > Hello, > > any exprerience with Hibernate + PostgreSQL ? How does this combination > is flexible and smart ? Is't possible to tune selected queries ? In short, it sucks :). L

[GENERAL] Cascading Trigger Prevention

Hello All, I have a table that contains a nested set (using paths), and I'm trying to create a trigger that updates the timestamps of a node and all of its parents on a modification. Unfortunately, this is causing infinitely recurring triggers. The insert occurs, which fires the trigger, which t

[GENERAL] certificate based authorization

Hello Is there a way to use certificate based authorization with postgresql? I already implemented authentication, but among the people that my CA certifies, and which I trust by the way, I want to distinguish to a particular server who I grand access and who I don't even if they are who they cla

Re: [GENERAL] postgres 8.3 beta 2 storage question

2007/11/27, SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]>: > 1.How does postgres version 8.3 betat 2 handle varchar and numeric data > types in terms of storage > I understand for varchar it has 1byte overhead (instead of 4) if length<128 > How does it handle for numeric? The manual says > "The actual s

[GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

I added the following line to postgresql.conf file: log_line_prefix='%t %u %d %h %p %i %l %x ' but got error. 2007-11-29 12:40:41 LOG: syntax error in file "D:/Program Files/PostgreSQL/8.2/data/postgresql.conf" line 482, near token "%" I checked and all options are legal. What I'm doing wro

Re: [GENERAL] \copy ... with null as '' csv doesn't get nulls

Lew wrote: Try eliminating the double quotes in the CSV file. "Wannabe" NULL would then be ,, (consecutive commas) in the CSV. From the docs, you don't even need the "NULL AS" clause in your COPY statement. Ivan Sergio Borgonovo wrote: Exactly what I did because fortunately there weren't too

[GENERAL] Postgres High Availablity Solution needed for hot-standby and load balancing

Hi our customer has got the following requirements: Req1) Master master replication supported, not only master / slave replication with only the master being writable. If you do have multiple slave systems they are only useful from a backup and standby perspective. Our Application must have a db

[GENERAL] Porting from FrontBase

I am looking at porting a web application from FrontBase to Postgresql. If anybody has some tips on how to deal with this, I'd appreciate hearing him. Thanks. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

[GENERAL] Postgres WarmStandby using ZFS or Snapshot to create Web DB?

I am looking for suggestions in setting up a large postgres database scenario. We are running a science project with a lot of data expected from the science instrument. If you have time to comment, any advice is most welcome! Here's the deal: 1. We expect to store ~1TB per year of data for 10 y

Re: [GENERAL] 1 cluster on several servers

This is the system i am talking about: http://people.planetpostgresql.org/xzilla/index.php?/archives/326-Solving-the-big-science-checklist.html There are many parties involved, and i am trying to figure out what configuration would be ideal for ours. On Nov 29, 2007 3:20 PM, Geoffrey <[EMAIL PROT

[GENERAL] pgcrypto functions fail for asymmetric encryption/decryption

Hi, I have a table with userids and public keys. I want to write a function which does a select and returns the result pgp encrypted. However, I have some problems: SELECT encode(decode((SELECT ens_pubkey FROM ens_user)::text,'escape'),'escape'::text)::text; -> returns the public key, => ok SELE

Re: [GENERAL] Help needed optimizing query

On Thu, Nov 29, 2007 at 01:26:00PM +, Pedro Doria Meunier wrote: > Hi People. > > I need some help optimizing this query: > I still get Seq Scans although all used fields are indexed, hence the > time used... :-( A seq scan on a table with 10 rows is *good*. An index would take longer. What

Re: [GENERAL] Threads limit for postmaster

Guillaume Pungeot wrote: > Hi, > I have a problem when a lot of connexions are opened on postgresql. > > When 243 threads have been created by postmaster, the next CreateThread > fails and the following error is written in pglogs : "FATAL: could not > create sigchld waiter thread: error code 8".

Re: [GENERAL] Porting from FrontBase

On 29.11.2007, at 12:30, Martin wrote: I am looking at porting a web application from FrontBase to Postgresql. If anybody has some tips on how to deal with this, I'd appreciate hearing him. Thanks. If it is WebObjects, you can contact me off-list. I've done that for some of our apps. It's no

Re: [GENERAL] problems with email...

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I seem to have *extreme* problems sending messages to this list... :-( > Could one of the people responsible for the list see if anything is > wrong with my account, please? Out apologies. I've manually approved your earlier message. It got c

Re: [GENERAL] Porting from FrontBase

On Thu, Nov 29, 2007 at 07:30:53PM -, Martin wrote: > I am looking at porting a web application from FrontBase to > Postgresql. If anybody has some tips on how to deal with > this, I'd appreciate hearing him. Thanks. FrontBase has a Perl DBI driver

Re: [GENERAL] can't createdb with my new user

On 28/11/2007 14:02, della wrote: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "kokomo" So, given that I do not fail submitting the password for kokomo when requested... what could be the problem? Have I to create a system user for kokomo? If I

[GENERAL] Linux v.s. Mac OS-X Performance (now Solaris)

> Only under Solaris. With Linux or BSD on it it ran pretty well. I > had a Sparc 20 running RH 7.2 back in the day (or whatever the last > version of RH that ran on sparc was) that spanked an Ultra-2 running > slowalrus with twice the memory and hard drives handily. > > Solaris has gotten much

Re: [GENERAL] 60 Seconds to connected to Postgresql using ODBC or PGAdmin

Or you can try using a simple packet sniffer, maybe ,ethereal , to see if name resolution is going on, i had similar problems with MySQL name resolution in the past and they generally went away after disabling its name resolution and just use IPs On Nov 29, 2007 1:23 PM, Shane Ambler <[EMAIL PROTE

[GENERAL] Threads limit for postmaster

Hi, I have a problem when a lot of connexions are opened on postgresql. When 243 threads have been created by postmaster, the next CreateThread fails and the following error is written in pglogs : "FATAL: could not create sigchld waiter thread: error code 8". I need to open more than 300 connexi

[GENERAL] Help needed optimizing query

Hi People. I need some help optimizing this query: SELECT u.friendly_name, distance(transform(u.curr_location,32628), rc.agg_geometry) AS thedistance, u.mobile FROM (SELECT transform(collect(r.geometry),32628) AS agg_geometry, t.county FROM pt_madeira_roads r, pt_madeira_toponymy t WHERE r.name

Re: [GENERAL] PostgresSQL vs. Informix

In answering the question, it might help to have information on two background items. The first item is the politics of the situation. I gather from Chad Hendren's post that an individual in the top-8-OEM-customer enterprise is advocating for Postgresql. The second item is the existing tech

[GENERAL] can't createdb with my new user

hi, I describe my steps: 1. installed postgresql 8.2 via apt-get (ubuntu gutsy) 2. # sudo -u postgres psql template1 3. template1=# CREATE ROLE kokomo WITH LOGIN CREATEDB PASSWORD 'kokomo'; 4. template1=# \q 5. # createdb kokomo_dev -U kokomo -W Here I receive: createdb: could not connect to data

Re: [GENERAL] Cascading Trigger Prevention

On Wed, Nov 28, 2007 at 02:00:58PM -0800, JonXP wrote: > I have a table that contains a nested set (using paths), and I'm > trying to create a trigger that updates the timestamps of a node and > all of its parents on a modification. Unfortunately, this is causing > infinitely recurring triggers. >

Re: [GENERAL] \copy ... with null as '' csv doesn't get nulls

On Tue, 27 Nov 2007 21:12:00 -0500 Lew <[EMAIL PROTECTED]> wrote: > Lew wrote: > >> Try eliminating the double quotes in the CSV file. "Wannabe" > >> NULL would then be ,, (consecutive commas) > >> in the CSV. From the docs, you don't even need the "NULL AS" > >> clause in your COPY statement. >

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

Andrus wrote: log_line_prefix='%t %u %d %h %p %i %l %x ' I checked and all options are legal. That works fine for me... are you sure log_line_prefix is line 482 in your config file? You might have inadvertently put a superfluous % somewhere else. -- Paul Lambert Database Administrator Aut

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

Hi, I'm not sure if this is good netiquette, or not. I'm reviving a month-old thread, because I'm trying to figure out how to resolve the issue. To summarize: when I run unit tests with eclipse (and with Ant) on Windows, at some point, I run out of available connections. I tried increasing the ma

  1   2   >