[GENERAL] upgrading from 8.3 to 9.0

problems with restoring from a pgadmin's .backup file in the past... :S Any pitfalls I should be aware of? Btw: it's a reasonably large DB with 30mil+ rows... Already thankful for any insight, -- Pedro Doria Meunier GSM: +351 91 581 88 23 Skype: pdoriam signature.asc Description

Re: [GENERAL] need some advanced books on Postgres

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I hope postgres will be as popular as linux one day , :) Where have you been all these years?!?!? Postgresql is THE database! humph! On 03/05/2010 10:01 AM, Thomas wrote: Good advice ,tks both of you . For database books ,I found so many good

Re: [GENERAL] Cannot login, with C/C++ program

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Did you check you pg_hba.conf ? another thing: although port defaults to 5432 you *should* specify that in the connection string. also... is sysdba *really* an authorized user? check your permissions... BR, Pedro. On 12/02/2009 09:42 PM, Tom Lane

Re: [GENERAL] obtaining ARRAY position for a given match

Regarding this thread... I've been away for a while... But thank you to all who replied! :) BR, Pedro On 11/19/2009 07:03 PM, Sam Mason wrote: On Thu, Nov 19, 2009 at 10:47:02AM -0800, Scott Bailey wrote: Sam Mason wrote: Is idx really the best name for this? Well I used

[GENERAL] C++ and Postgis

Hi All, First off sorry for cross-posting. I'm hoping for a bigger audience... :] As for my question: How does one deal with Postgis geom fields in C++ ? Google hasn't offered much help so far. I know I can make a SELECT astext(my_geom) FROM my_table and after parsing the resulting text.

[GENERAL] obtaining ARRAY position for a given match

' is stored? Searching the Postgresql docs gives me no answer... :( Am I on a wild goose chase? Any insight highly appreciated ;) BR, Pedro Doria Meunier. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

Re: [GENERAL] [pgeu-general] pgday.eu

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ok a *bit* off-topic here... ;-) But who's this? He reminds me after a programming maraton! :-D Or after a cognac after red wine! :-P Whoever your are... Cheers Mate! ;) BR, Pedro On 11/12/2009 05:24 PM, Dave Page wrote: 2009/11/12 Alvaro Herrera

[GENERAL] Posgresql to MSsql encoding problem

... :( I cannot simply use Set Client Encoding to LATIN1 as the client itself is the script ... :) Is there a simple way to circumvent this? Already thankful for any info, Best regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG

Re: [GENERAL] Posgresql to MSsql encoding problem

the aforementioned connection... So, to all effects, the script is *the* client... :) Best regards, Pedro Doria Meunier On 10/09/2009 02:38 PM, Sam Mason wrote: On Fri, Oct 09, 2009 at 11:39:47AM +0100, Pedro Doria Meunier wrote: I cannot simply use Set Client Encoding to LATIN1 as the client

Re: [GENERAL] [EDIT] Timestamp indicies not being used!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Alban for your considerations. The issue has already been marked as [SOLVED] following Sam's suggestion. And FYI the issue *was* urgent and the wolf *was* biting my leg! :] BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam

[GENERAL] Timestamp indicies not being used!

... :-( Could someone PLEASE tell me how can I solve this? Thanks in advance, -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] [EDIT] Timestamp indicies not being used!

to the my_table these queries effectively block other and take postgresql to a screeching halt ... :-( Could someone PLEASE tell me how can I solve this? Thanks in advance, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU

[SOLVED] Re: [GENERAL] Timestamp indicies not being used!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 First of all *thank* you very much to all that replied! :) Sam's suggestion actually did the trick! I created the multi-column index and the stalling went away. Yay! Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Tom

Re: [GENERAL] c++ program to connect to postgre database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Rey, If you give QT4 a try I might be able to help you there ;-) Regards Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam ramon rhey serrano wrote: !-- DIV {margin:0px;} -- Hello, I'm thinking of making a program in C++ (API

Re: [GENERAL] sslv3 alert illegal parameter [SOLVED]

feeling ... Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Albe Laurenz wrote: Pedro Doria Meunier wrote: My server started spitting this out every second! LOG: could not accept SSL connection: sslv3 alert illegal parameter PostgreSQL 8.3.7 on x86_64-redhat-linux

[GENERAL] sslv3 alert illegal parameter

in place.. What can I do about it?! TIA, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKVHAz2FH5GXCfxAsRAixyAJ9m3TxToFE1sNdeDz9SsB9IoU/Q9wCePy3T

Re: [GENERAL] pgAdmin - no_spool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks Simon, Actually Dave has already made a patch that overcomes this issue and it's already been committed! BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Simon Riggs wrote: On Tue, 2009-06-30 at 09:27 +0100, Pedro Doria

[GENERAL] pgAdmin - no_spool

on localhost TIA, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKScxm2FH5GXCfxAsRArT8AJ0cOQok2fGxBjlZkgnY0DKMlUwivwCdHx89 u0d+m9gCvCQJMyo7Yo2hDX8= =vEzG

[GENERAL] Slony-I timezone setting

' and UTC. My postgresql.conf has the same setting ('Atlantic/Madeira') Postgresql ver. 8.3.7 on Fedora 8 I feel reluctant to follow Slony's 'Best practices' depicted in the (cough) fine manual as it would mean losing any DST awareness ... Any thoughts appreciated, TIA, - -- Pedro Doria Meunier

Re: [GENERAL] Slony-I timezone setting

= 'Atlantic/Madeira' BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Tom Lane wrote: Pedro Doria Meunier pdo...@netmadeira.com writes: When configuring a Slony cluster I get the infamous 'ERROR: invalid input syntax for type timestamp: Mon Jun 29 13:00:36.628805 2009 WEST' You

Re: [GENERAL] Slony-I timezone setting

And this is when I ran out of ideas... btw: do you happen to know of a Slony mailing list? TIA, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Tom Lane wrote: Pedro Doria Meunier pdo...@netmadeira.com writes: This is what's defined in postgresql.conf datestyle = 'iso, ymd' timezone

[GENERAL] Optimal values for 500 connections

appreciated ;-) BR, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKRRhy2FH5GXCfxAsRAt7KAJ0eiq6dcDyuvK5JpcfLb8atGd9FUACgo1TG

Re: [GENERAL] Optimal values for 500 connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Scott! As always your advice is right to the point ;-) That solved it. Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Scott Marlowe wrote: On Fri, Jun 26, 2009 at 12:52 PM, Pedro Doria Meunierpdo

[GENERAL] Postgresql 8.3.7 SSL support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi (again :] ) PGSQL 8.3.7 rpms for x86_64 aren't compiled with ssl support?! I've my server.* files in the data folder but this is what I get: Error connecting to the server: server does not support SSL, but SSL was required BR, - -- Pedro Doria

Re: [GENERAL] Postgresql 8.3.7 SSL support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 (blush) (blush) Sorry for the noise I forgot to ssl=on in postgresql.conf (blush) (blush) Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Pedro Doria Meunier wrote: Hi (again :] ) PGSQL 8.3.7 rpms for x86_64 aren't compiled

[GENERAL] Upgrade

to tackle the upgrade for these two servers (especially the FC6 one) would be much appreciated! ;-) Thanks in advance. BR. - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http

Re: [GENERAL] Upgrade

this arch is EOL and there are no upgrade packages available... :-( Perhaps someone is able to conjure up some sort of solution for this? TY, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Greg Stark wrote: On Thu, Jun 25, 2009 at 1:28 PM, Guy Flahertynaosh...@gmail.com wrote

Re: [GENERAL] 10 TB database

, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Michelle Konzack wrote: Hi Artur, I am owner of a database about War, Worcrime and Terroism with more then 1,6 TByte and I am already fscked... Am 2009-06-15 14:00:05, schrieb Artur: Hi! We are thinking to create some stocks

[GENERAL] Average connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all I've googled for an answer but couldn't find one. Is there anyway to monitor the average connections to a database? Thank you in advance for any insights. BR, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP

Re: [GENERAL] Average connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Bill for your tip. As far as the table's name is concerned the only one I can find is 'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64. BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Bill Moran wrote

Re: [GENERAL] Average connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, First of all thank you very much to everyone that shared their views on the task at hand! I've actually accomplished it using MRTG :) BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Bill Moran wrote: In response

Re: [GENERAL] Internationalization

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Sam for the valuable input! Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Sam Mason wrote: On Sat, Apr 11, 2009 at 02:47:53AM +0100, Pedro Doria Meunier wrote: Actually what I have is a fully

[GENERAL] Internationalization

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm wondering how to internationalize contents of a table, short of having a column for each language string ... Anyone with some experience to share? :) Regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU

Re: [GENERAL] Internationalization

, Pedro Doria Meunier. Justin wrote: Pedro Doria Meunier wrote: Hi all, I'm wondering how to internationalize contents of a table, short of having a column for each language string ... Anyone with some experience to share? :) Regards, Pedro Doria Meunier How about parent child table layout

Re: [GENERAL] Accent insensitive search?

Hi, use ILIKE HTH, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March 2009 04:29:24 pm cifroes wrote: Hi, I have a DB in utf-8 and postgres 8.3.x. How can I do an accent insensitive search (like ...) ? TIA signature.asc Description: This is a digitally

Re: [GENERAL] Accent insensitive search?

Ooops! Silly me! I should have read more carefully ... (blush) sorry! Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March 2009 04:46:16 pm Pedro Doria Meunier wrote: Hi, use ILIKE HTH, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

for a number of reasons: - proven robustness - tight integration with PostGIS - large user base (an always friendly bunch willing to help out each other ;-) ) - ... Regards, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Tuesday 17 March 2009 11:25:08 am Juan Pereira wrote: Hello, I'm

[GENERAL] to_hex leading zeroes

Hi All, I'm in a bit of a pickle here with the to_hex function not returning leading zeroes ... For instance if I: SELECT to_hex(10); it returns 'a' not '0a' . Any ideas on how to overcome this? TIA, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam signature.asc Description

[GENERAL] COPY ... FROM Permission denied ...

someone please lend a hand? Thanks in advance, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] COPY ... FROM Permission denied ...

as expected. :] Thanks again. Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Tuesday 06 January 2009 06:48:47 pm Scott Marlowe wrote: On Tue, Jan 6, 2009 at 11:41 AM, Pedro Doria Meunier pdo...@netmadeira.com wrote: Hi All, This is a bit embarassing ... but ... I have a partial

Re: [GENERAL] Hi iam the beginner

(sorry all, I *couldn't* resist!) Scott ... In all these years that's the 1st time I've ever 'heard' the term massage you data !!! All sorts of deviant thoughts come to your mind! LOL BR, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Friday 19 December 2008 12:03:26 am Scott

[GENERAL] pgadmin3

Hi guys, What happened to pgadmin3 rpms for fedora core 10? Aren't they built yet? BR, Pedro Doria Meunier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Copying data from a table to another database

was concerned (entry_nbr) it didn't cause me any problems as what's important were the timestamps in the relevant column. Again thanks! Best regards, -- Pedro Doria Meunier [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Copying data from a table to another database

? Already thankful for any insight, -- Pedro Doria Meunier [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part

[GENERAL] default value based on select

Hi, Is it possible to have a table's column default value set to some form of select? e.g. picking another table's value for a given SELECT ... WHERE ... Already thankful for any insight, -- Pedro Doria Meunier Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y 9125-162 Caniço Madeira

Re: [GENERAL] default value based on select

? :) Kind regards, -- Pedro Doria Meunier Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y 9125-162 Caniço Madeira - Portugal -- Skype : pdoriam Mobile: +351961720188 signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] Very slow catalog query

process for each connection. this eats up resources quite quickly Did you check your system processes with 'top' ? how's it looking for swap usage? Regards, -- Pedro Doria Meunier Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y 9125-162 Caniço Madeira - Portugal

Re: [GENERAL] thank you

)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ -- 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 Skype: pdoriam http://www.madeiragps.com

[GENERAL] Slony replication

Hi All, I would like to implement DB replication with Slony but with a slave that will not be always available. The master would have to check first of the slave's availability and then start syncing... Is this at all possible, or am I just raving? : ) Kind regards, -- Pedro Doria Meunier Ips

[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

[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

[GENERAL] Help needed optimizing query

! -- 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 Skype: pdoriam http://www.madeiragps.com signature.asc Description: This is a digitally signed message part

Re: [GENERAL] [pgadmin-support] Problem editing tables (geom columns)

processor time. Dave I've tested with a micro-subset of my data (only one record with a small parish geometry) and it shows although the slowness is immediately apparent... /Dave Kind regards, Pedro Doria Meunier Dave Page wrote: Dave Page wrote: Pedro Doria Meunier wrote: I've seen in the known

[GENERAL] pgadmin3 1.6.3 problem with geom fields

and it exhibits the same behaviour... Any thoughts highly appreciated since I rely heavily on pgadmin3 for my work! :) Kind regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Remi - http://enigmail.mozdev.org

[GENERAL] help with a query

as to compute the time difference. ;-) Thanks in advance! Pedro Doria Meunier (351) 91 302 49 72 - (351) 96 247 99 12 [EMAIL PROTECTED] MSN - [EMAIL PROTECTED] ICQ - 308-182-126 Skype: pdoriam