Re: [GENERAL] SQLite-PostgreSQL comparison

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Jun 05, 2011 at 05:17:30PM +0200, Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? Just google around a bit:

Re: [GENERAL] Question about configuration and SSD

On 02/06/11 18:53, Craig Ringer wrote: On 02/06/11 16:26, Szymon Guz wrote: Hi, do we need some special configuration for SSD drives, or is that enough to treat those drives normally? Make sure the SSDs have a supercapacitor or battery backup for their write cache. If they do not, then do not

Re: [GENERAL] Index on substring

2011/6/5 Håvard Wahl Kongsgård > Hi, my database performance badly on substring comparison between two very > large tables. > In postgresql 8.4 is it possible to create a index on a substring, or must > I create an new field for the substring match ( and then create a new index > for that field)?

[GENERAL] Index on substring

Hi, my database performance badly on substring comparison between two very large tables. In postgresql 8.4 is it possible to create a index on a substring, or must I create an new field for the substring match ( and then create a new index for that field)? -- Håvard Wahl Kongsgård http://havard.

Re: [GENERAL] EnterpriseDB-xDBReplicationServer java process on OS X.

On 06/05/2011 03:32 AM, piscesboy wrote: I have a process called "java" showing up in my Activity Monitor that uses a good amount of CPU (4 - 8% average, 100 - 120% on occasion). It reports that "launchd" is its parent process and that postgres is its user. I did a ps axv|grep java and found out

Re: [GENERAL] SQLite-PostgreSQL comparison

On Sunday, June 05, 2011 8:17:30 am Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? > As part of a more general comparison: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems The thumbnail version based on my experiences: 1)

[GENERAL] EnterpriseDB-xDBReplicationServer java process on OS X.

I have a process called "java" showing up in my Activity Monitor that uses a good amount of CPU (4 - 8% average, 100 - 120% on occasion). It reports that "launchd" is its parent process and that postgres is its user. I did a ps axv|grep java and found out that it is the edb- repserver.jar doing so

Re: [GENERAL] SQLite-PostgreSQL comparison

On 5 Jun 2011, at 17:17, Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? Indirectly, yes: http://en.wikipedia.org/wiki/Apples_and_oranges Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSP

[GENERAL] SQLite-PostgreSQL comparison

Does anyone know of a document comparing SQLite and PostgreSQL ? Thanks in advance. -- André Majorel http://www.teaser.fr/~amajorel/ -- 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] how to run psql without password prompt when using auth MD5/Password

sorry, didn't saw the other option. setting PGPASSWORD does the trick, even with md5. thanks!! E. On Sun, Jun 5, 2011 at 2:28 PM, eyal edri wrote: > of course trust is a way :) > > but i need a more secure way, as my company requires.. like md5. > only i want to be able to enter the password

Re: [GENERAL] how to run psql without password prompt when using auth MD5/Password

of course trust is a way :) but i need a more secure way, as my company requires.. like md5. only i want to be able to enter the password in the command line and not be promoted (so a script can do it). eyal On Sun, Jun 5, 2011 at 2:21 PM, Grzegorz Szpetkowski wrote: > Sure, > > > http://stack

Re: [GENERAL] how to run psql without password prompt when using auth MD5/Password

Sure, http://stackoverflow.com/questions/6216432/windows-psql-command-line-is-there-a-way-to-allow-for-passwordless-login/6216838#6216838 Regards, Grzegorz Szpetkowski 2011/6/5 eyal edri : > Hi, > Is there a way to run psql -U user -d dbname -c "select." > without the psql asking for a passw

[GENERAL] how to run psql without password prompt when using auth MD5/Password

Hi, Is there a way to run psql -U user -d dbname -c "select." without the psql asking for a password prompt from the user? when setting the pg_hba.conf file to use md5 or password. (btw, i've tried using ident, but couldn't make it work with jboss). thanks! Eyal.