[GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

Hi all, I'm wondering if someone here know how to go about fixing this problem that apparently affects everyone who manually install Postgresql8.4 on Ubuntu Karmic(9.10). Postgres installation seems to mess with something that renders other applications unable to function. For instance my problem

[GENERAL] Locale query

Hi, I have a query re localization. I am running Centos 4.3 and am using a CMS using Postgresql 8.1.18-2 (installed via yum). The documentation for the CMS advise to ensure Postgresql is initialised with C locale for performance reasons. To accomplish they advise: 1. in /etc/sysconfig/i18n

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

A quick-fix solution is deleting the file '/opt/PostgreSQL/8.4/lib/libxml2.so.2'. On 11/28/2009 04:23 PM, Leonardo Camargo wrote: Hi all, I'm wondering if someone here know how to go about fixing this problem that apparently affects everyone who manually install Postgresql8.4 on Ubuntu Kar

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

On Sat, Nov 28, 2009 at 11:53, Leonardo Camargo wrote: > Hi all, > I'm wondering if someone here know how to go about fixing this problem that > apparently affects everyone who manually install Postgresql8.4 on Ubuntu > Karmic(9.10). > > Postgres installation seems to mess with something that rend

Re: [GENERAL] Locale query

Hi, I have a query re localization. I am running Centos 4.3 and am using a CMS using Postgresql 8.1.18-2 (installed via yum). The documentation for the CMS advise to ensure Postgresql is initialised with C locale for performance reasons. To accomplish they advise: 1. in /etc/sysconfig/i18

[GENERAL] Date with time zone

Hello list, this is my first msg here. I hope this is the correct place for this subject, I couldn't find any more specific list for this. This thought had been bugging me for some time now and I thought it was time to share it with you pg gurus. Why in god's sake is there not a "date with time z

[GENERAL] Strange "bug" in dump ?

Dear all, When doing a dump of a 8.1.17, database (that I have to reimport daily into a 7.4.6), I have a strange bugs with accents... First point, I had to add --insert. But there is still a problem with accents. If I say nothing the dump is utf8, or I can add -E=latin1. But in both cases it f

Re: [GENERAL] Strange "bug" in dump ?

On Sat, Nov 28, 2009 at 12:59, Denis BUCHER wrote: [...] > There is a "E" before the street field ! > > This is an extract of the dump : > > 'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5', Sounds like escape quoting to me. You can read about it at

Re: [GENERAL] Strange "bug" in dump ?

Rikard Bosnjakovic a écrit : >> There is a "E" before the street field ! >> >> This is an extract of the dump : >> >> 'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5', > > Sounds like escape quoting to me. You can read about it at >

Re: [GENERAL] Locale query

On Sat, Nov 28, 2009 at 09:46:18PM +1100, ad...@buydirect.net.au wrote: > Is everything ok with the above or something has gone wrong? I guess I > was expecting the locale command would show C instead of POSIX. The "C" and "POSIX" locales are one and the same thing. Regards, Roger -- .''`.

[GENERAL] Postgres security article

FYI I thought it was a good read, hope someone else finds it useful http://www.ibm.com/developerworks/opensource/library/os- postgresecurity/index.html Colin -- You own a dog, but you can only feed a cat. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Postgres security article

Colin Streicher a écrit : > FYI > I thought it was a good read, hope someone else finds it useful > > http://www.ibm.com/developerworks/opensource/library/os- > postgresecurity/index.html > > Colin Very nice page indeed, Colin, Thanks! -- Aliquid melius quam pessimum optimum non est. -- Se

Re: [GENERAL] Postgres security article

On 11/28/2009 7:47 AM, Colin Streicher wrote: http://www.ibm.com/developerworks/opensource/library/os- postgresecurity/index.html Nice link, but it got broken for me: http://tinyurl.com/ylro9y9 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] postgres log file mode

Is it possible to force file mode of postgres log files, eg. as if it was changed by chmod 640 /log/file.log at present (I use 8.4.1) it is generated with mode 600. the goal is to let users in "postgtres" group to read these files. thanks in advance. -- Filip Rembiałkowski JID,mailto:filip.r

Re: [GENERAL] Cannot allocate memory for output buffer

On Fri, Nov 27, 2009 at 05:55:30PM -0500, Peter Erickson wrote: > Thanks. Out of curiosity, if memory exhaustion was the problem, any idea > why the task manager would show that I'm only using 1.2GB of the 3GB of > memory? Note that what usually kills you first on 32-bit systems is that you wa

Re: [GENERAL] Strange "bug" in dump ?

Denis BUCHER writes: > But this seems to be a 8.4 feature not supported by 7.4.6 ? > If you have an idea on how to have 7.4.6 accept it... Better idea: expend your effort on getting off 7.4.x. It's going to be EOL'd soon. Running a release as old as 7.4.6 doesn't seem very advisable anyway.

Re: [GENERAL] return value for PQbinaryTuples

On Fri, Nov 27, 2009 at 3:33 AM, bbhe wrote: > hi all, > > I don't why PQbinaryTuples function returns 1 > even the select statement only returns two integer fields. > Although there are some columns with type bytea in the table. PQbinaryTuples is basically going to return whatever you passed int

Re: [GENERAL] Date with time zone

On Saturday 28 November 2009 3:43:02 am Eduardo Piombino wrote: > Hello list, this is my first msg here. I hope this is the correct place for > this subject, I couldn't find any more specific list for this. > > This thought had been bugging me for some time now and I thought it was > time to share

[GENERAL] Public and Grants

I have a database with a schema called ISS. This is where all of our application defintions are stored. We did add 2 contribute modules (citext) and guid generator and both of these by default went to the public schema. It is our intent to not allow any access to public by our users. A few que

Re: [GENERAL] Access a Field / Column of a resultset by Number

hy scott, thanks for your awnser. yes thats clear. but i can't find any sourcecode. the pl* language doesnt matter, i need that feature only in one function all over my db. did you have any sourcecode examples? http://www.postgresql.org/docs/8.4/interactive/plperl-database.html nothing abou

Re: [GENERAL] vacuumdb -z do a reindex?

Hi Scott, Scott Marlowe wrote: On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg wrote: I've had a simple update running for over 4 hours now (see results from pg_top below). The sql is: Have you looked in pg_locks and pg_stat_activity? Yes, I did look at pg_stat_activity and did not see anythin

Re: [GENERAL] vacuumdb -z do a reindex?

Irene Barg wrote: avg-cpu: %user %nice %system %iowait %steal %idle 0.000.000.010.000.00 99.99 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sda 0.00 0.60 0.00 1.00 0.0012.80

Re: [GENERAL] Date with time zone

Hi Adrian, thanks for your answer. I see current criteria and all the SQL-standard compliance policy, but wouldn't it still make sense to be able to store a date reference, along with a time zone reference? Wouldn't it be useful, wouldn't it be elegant? If i just want to store a reference to "Dec

Re: [GENERAL] vacuumdb -z do a reindex?

On Sat, Nov 28, 2009 at 3:12 PM, Irene Barg wrote: > Hi Scott, > > Scott Marlowe wrote: >> >> On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg wrote: >>> >>> I've had a simple update running for over 4 hours now (see results from >>> pg_top below). The sql is: >> >> Have you looked in pg_locks and pg_

Re: [GENERAL] Date with time zone

On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote: > Hi Adrian, thanks for your answer. > > I see current criteria and all the SQL-standard compliance policy, but > wouldn't it still make sense to be able to store a date reference, along > with a time zone reference? > Wouldn't it be u

Re: [GENERAL] Date with time zone

Eduardo Piombino writes: > I see current criteria and all the SQL-standard compliance policy, but > wouldn't it still make sense to be able to store a date reference, along > with a time zone reference? > Wouldn't it be useful, wouldn't it be elegant? It seems pretty ill-defined to me, considerin

[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

On 19 nov., 16:36, t...@sss.pgh.pa.us (Tom Lane) wrote: > Tech 2010 writes: > >> xy=# reindex table xy_data; > >> ERROR:  concurrent insert in progress > > Should I drop and recreate indexes? > > I think that database is pretty well hosed.  (What happened to it to > cause all this, anyway?)  A dum

Re: [GENERAL] incorrect restore from pg_dumpall

Yes, You were right, the problem was in the different libraries. I worked around by installing the postgis version 1.3.6, reloading the databases and subsequently uprading the postgis to 1.4.1. Thank You for Your help Tomas p.s.: what is really a mystery that also the mentioned table with no dat

Re: [GENERAL] Date with time zone

Speaking of timestamps, I think it would be convenient to have a single-word alias for "timestamp with time zone". This is the date type I use almost exclusively and its name is annoyingly big. On Sat, Nov 28, 2009 at 6:57 PM, Tom Lane wrote: > Eduardo Piombino writes: >> I see current criteri

Re: [GENERAL] Date with time zone

timestamptz On Sat, Nov 28, 2009 at 7:25 PM, silly wrote: > Speaking of timestamps, I think it would be convenient to have a > single-word alias for "timestamp with time zone". This is the date > type I use almost exclusively and its name is annoyingly big. > > > > On Sat, Nov 28, 2009 at 6:5

Re: [GENERAL] Where do you store key for encryption

David Wall wrote: > In our open-esignforms project we use a layered approach for keys in > which we have a boot key for the application that requires dual > passwords which we then combine into a single password for PBE > encryption of the boot key. We then have session keys that are > encrypt

[GENERAL] 8.45.1 on mac - Plist problems

Hi all, Using a MacBook Pro. Snow Leopard installed along with XCode I have 8.4.1 compiled from tar.gz. It lives in /usr/local/postgresql-8.4.1 which is owned by root. the data subdirectory is owned by postgres. A link exists from /usr/local/postgres to postgresql-8.4.1. PGDATA is /usr

Re: [GENERAL] Date with time zone

On Sat, Nov 28, 2009 at 4:57 PM, Tom Lane wrote: > Eduardo Piombino writes: >> I see current criteria and all the SQL-standard compliance policy, but >> wouldn't it still make sense to be able to store a date reference, along >> with a time zone reference? >> Wouldn't it be useful, wouldn't it be

[GENERAL] Time zone 'GMT+8'

The target pgsql is compiled from 8.4rc1. 'GMT+8' can be found in installed binary file .../share/postgresql/timezone/Etc/GMT+8. This is the recorded script: -BEGIN record-- db1=# select now(); now --- 2009-11-29 14:44:37.32241

Re: [GENERAL] Time zone 'GMT+8'

>From >http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES Another issue to keep in mind is that in POSIX time zone names, positive offsets are used for locations west of Greenwich. On Sun, Nov 29, 2009 at 2:08 AM, wrote: > The target pgsql is compiled fr