[GENERAL] upgrading from 8.3 to 9.0

o remember 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 De

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 w

[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. T

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] obtaining ARRAY position for a given match

ion at which 'L' 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 - h

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

Re: [GENERAL] Posgresql to MSsql encoding problem

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

[GENERAL] Posgresql to MSsql encoding problem

erish... :( 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/Li

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: pd

[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

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

27;::bpchar)" "Total runtime: 810808.298 ms" Since there are hundreds of devices delivering their data payload 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

[GENERAL] Timestamp indicies not being used!

of devices delivering their data payload 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 -- Sent via pg

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

angling-over-my-head 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 >&

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: > > Hello, > > I'm thinking of making a program in C++ (API)

[GENERAL] sslv3 alert illegal parameter

ver key 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

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, Ped

[GENERAL] pgAdmin - no_spool

stalled 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+m9gCvCQJMyo7Yo2h

Re: [GENERAL] Slony-I timezone setting

one name: "WEST" 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 writes: >> This is what's defined in postgresql.conf &g

Re: [GENERAL] Slony-I timezone setting

nf datestyle = 'iso, ymd' timezone = 'Atlantic/Madeira' BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Tom Lane wrote: > Pedro Doria Meunier writes: >> When configuring a Slony cluster I get the infamous 'ERROR: >> invalid input syntax for

[GENERAL] Slony-I timezone setting

to 'Atlantic/Madeira' 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 ... An

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&#

[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, - -- P

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 > Meunier

[GENERAL] Optimal values for 500 connections

ighly 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 iD8DBQFKRRhy2FH5GXCfxAsRAt7KAJ0eiq6dcDyuvK5JpcfLb8atGd9FUAC

Re: [GENERAL] Upgrade

r is concerned to my great frustration 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 F

[GENERAL] Upgrade

ice (sweat)... Insight on how 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) Commen

Re: [GENERAL] 10 TB database

... :) BR, 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! &g

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 res

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

[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

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 i

Re: [GENERAL] Internationalization

. Regards, 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? :) >>

[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

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

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.as

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

than MySQL 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

[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

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

thing worked 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 > > wrote: > > Hi All, > > > > This is a bit embarassing .

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

ry basic Could 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] 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

[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

s the pkey 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.or

[GENERAL] Copying data from a table to another database

one please lend me a hand here? Already thankful for any insight, -- Pedro Doria Meunier <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

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.

[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

Re: [GENERAL] Very slow catalog query

related blog: http://devblog.famundo.com Hi 'Just Someone' I'm wondering... just 4GB of ram? What's the "normal" "hammering" -- a.k.a. user access -- to all of this? PG, as expected, launches a separate process for each connection. this eats up resource

Re: [GENERAL] thank you

n-letter type ordeal. > > The point is that I hope you realize just how much you all mean to the > community. > > Kevin > > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.post

[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

[GENERAL] Help needed optimizing query

int)" "Filter: (((even_code)::text = 'A'::text) OR ((even_code)::text = 'B'::text))" I still get Seq Scans although all used fields are indexed, hence the time used... :-( Although this is almost 'targeted' to the beautiful SQL head of Regina's any input would be extremely appreciated... ;-) Thank you! -- 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

[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] 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

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

gs way too much processor time. 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... Kind regards, Pedro Doria Meunier Dave Page wrote: > Dave Page wrote: >> Pedro Doria Meunier wrot

[GENERAL] pgadmin3 1.6.3 problem with geom fields

3 1.6.3 to 1.6.2 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:/

[GENERAL] help with a query

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