[GENERAL] xml import/export tools and performance

I need to import/export through xml files. I was looking for tools/examples/HOWTO for postgresql. Right now I still don't know the details of the requirements. I know I won't need a GUI. I know one of the exporting parties will be a MS SQL 2005 server, so it would be nice if there was an easy w

Re: [GENERAL] MD5 Authentication

I'm blocked ... On 06/11/2009, at 6:27, John DeSoi wrote: On Nov 5, 2009, at 12:35 PM, Raimon Fernandez wrote: at least, my first md5 (psw+user) is the same as the pg_shadow (wihtout the 'md5') ... should I md5 the first md5 as I get it as string (like username) or byte by byte ?

Re: [GENERAL] PostgreSQL for 64 Bit Windows Version

a.bhattacha...@sungard.com wrote: Hello All, Can anybody help me on downloading 64 bit version of PostgreSQL for Windows environment? Do PostgreSQL for windows version supports 64 bit version? I don't believe anyone is building a standard package for Win64.. The 32bit version will

[GENERAL] PostgreSQL for 64 Bit Windows Version

Hello All, Can anybody help me on downloading 64 bit version of PostgreSQL for Windows environment? Do PostgreSQL for windows version supports 64 bit version? Many thanks

Re: [GENERAL] MD5 Authentication

John DeSoi writes: > ... But it is unclear to me what happens when > the user or database name has non-ascii characters. The client > encoding is not established until after authentication. No encoding conversion will happen on those names. If you consistently use the same encoding in all cl

Re: [GENERAL] Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres

On Thu, Nov 5, 2009 at 9:05 PM, Stephen Tyler wrote: > So far I have encountered zero errors on the SSD drives, and SMART > status is OK.  The SCSI U320 15K drives have given a few soft errors > over the past few years. Have you noticed any fall off in performance as they get re-written a lot? I

Re: [GENERAL] MD5 Authentication

On Nov 5, 2009, at 12:35 PM, Raimon Fernandez wrote: at least, my first md5 (psw+user) is the same as the pg_shadow (wihtout the 'md5') ... should I md5 the first md5 as I get it as string (like username) or byte by byte ? As far as I know, a string. But it is unclear to me what happens

[GENERAL] Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres

Chris Barnes wrote: >> Does anyone use solid state drives for postgres? >>  Has there been any benchmark that states whether mechanical disk drives out >> perform solid state drives? >>  Is there any benefit, they are quite expensive. I am currently running PostgreSQL 8.4.1 on a Mac Pro 2009 with

Re: [GENERAL] Three fields table: id-data-date_time, how to get max() and date_time same time?

zxo102 ouyang wrote: Hi everyone, I have a table "test" which has three fields: id data date_time 12 2009-10-1 12:12:12 110 2009-10-1 12:22:10 23 2009-10-1 12:10:32 21 2009-10-1 12:30:32 with the sql: selec

[GENERAL] Three fields table: id-data-date_time, how to get max() and date_time same time?

Hi everyone, I have a table "test" which has three fields: id data date_time 12 2009-10-1 12:12:12 110 2009-10-1 12:22:10 23 2009-10-1 12:10:32 21 2009-10-1 12:30:32 with the sql: select max(data), id from test w

Re: [GENERAL] Database connection error, try to reset the connection parameters

cholid wrote: when im login to some application that connection to postgres this message show "Database connection error, try to reset the connection parameters" any one can help me? not without a LOT more information. can you connect to postgres with the psql command line or pgadmin-III

[GENERAL] Database connection error, try to reset the connection parameters

Hi all, im newbie in here when im login to some application that connection to postgres this message show "Database connection error, try to reset the connection parameters" any one can help me? thanks regards cholid.r -- View this message in context: http://old.nabble.com/Database-connection-er

[GENERAL] PostgreSQL 8.5 Alpha2 RPMs released.

Hi, PostgreSQL RPM Building Project released RPM sets for 2nd Alpha of the upcoming 8.5 release. Please note that these packages are **not** production ready. They are for Fedora 7,8,9,11 and RHEL/CentOS 4,5. These packages *do* require a dump/reload, even from the first alpha packages, because

Re: [GENERAL] postgres logs indicate errors with prepared statements, since pgbouncer was installed.

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > We are using pgbouncer and seeing these errors in the postgresql logs. > ...ERROR: prepared statement "dbdpg_p1573_3968" does not exist > > I

Re: [GENERAL] Adding a null

Thanks Sam Worked perfectly. Bob - Original Message - From: "Sam Mason" To: Sent: Thursday, November 05, 2009 10:28 AM Subject: Re: [GENERAL] Adding a null On Thu, Nov 05, 2009 at 10:13:28AM -0800, Bob Pawley wrote: However one variable sometimes returns a null value which inva

Re: [GENERAL] Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres

On Thu, Nov 5, 2009 at 8:46 AM, Howard Cole wrote: > I use a single SSD on one of our servers and it appears to be much more > responsive than a single 15K SAS drive - Thats as scientific as my testing > gets! The database I use is mostly reads. > > Careful which SSD you choose because there is a

[GENERAL] adding a custom tsearch parser

i've been playing with the new built-in tsearch functionality and it's really, really cool. however, the default parser seems a overly complicated and non-principle-of-least-surprise - at least to me. for instance filename.jpg will not be found by a search for 'filename', since the default pars