Re: [GENERAL] Is there a way to start postgresql v907 as non daemon process

Karthik wrote: I have observed by default posgresql 8.x onwards starts as daemon process. Is there a way to avoid it. I want it to run as normal process. The parent of the server process should be the process that starts the server instead of being PID 1 ( init ). Till 7.4.2 ( Which was the

Re: [GENERAL] Is there a way to start postgresql v907 as non daemon process

Thank you Laurenz, Even executing $ postgres -D /data/directory Used to start server in deamon mode, the reason was the postgres.conf was having silent_mode = on ( freebsd port used to do this ). Got this solved by sending silent_mode=off command line. With this my problem is solved. Trying

Re: [GENERAL] Naming conventions

On 25/05/2012 02:21, Bruce Momjian wrote: On Wed, May 16, 2012 at 10:08:03AM +0100, Raymond O'Donnell wrote: On 15/05/2012 22:50, Scott Briggs wrote: So this is purely anecdotal but I'm curious, what's with all the different naming conventions? There's psql (for database connections), pgsql

[GENERAL] Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV

Hi all I just had the ... pleasure ... of using Windows with Pg again and was in a usability review frame of mind. I landed up trying to restore my database using PgAdmin-III, and was astonished at how difficult and painful it was. The issues weren't all PgAdmin-III either, there are a few

Re: [GENERAL] Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV

On Fri, May 25, 2012 at 12:56 PM, Craig Ringer ring...@ringerc.id.au wrote: I just had the ... pleasure ... of using Windows with Pg again and was in a usability review frame of mind.  I landed up trying to restore my database using PgAdmin-III, and was astonished at how difficult and painful

Re: [GENERAL] Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV

On 25/05/2012 6:55 PM, Marti Raudsepp wrote: Together with an earlier study about common PostgreSQL pitfalls, I've created an article on the wiki: https://wiki.postgresql.org/wiki/Usability_reviews However, I suspect posting long rants like this won't get us very far. Instead, I think these

Re: [GENERAL] Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 - 9.1

On Thu, May 24, 2012 at 12:57 PM, Tom Lane t...@sss.pgh.pa.us wrote: Lonni J Friedman netll...@gmail.com writes: On Thu, May 24, 2012 at 12:34 PM, Tom Lane t...@sss.pgh.pa.us wrote: Can you correlate the performance hit with any specific part of autovacuum? In particular, I'm wondering if it

[GENERAL] configuring library path for debian build of postgres 9.2

I'm trying to build postgres 9.2 beta1 on debian stable from sources, in a way that plays nicely with the debian cluster management stuff. If I configure with libdir=/usr/lib/postgres everything works but the shared libraries end up in the wrong place (ie just where I specified). If I configure

Re: [GENERAL] configuring library path for debian build of postgres 9.2

On 05/25/2012 03:05 PM, Marc Munro wrote: I'm trying to build postgres 9.2 beta1 on debian stable from sources, in a way that plays nicely with the debian cluster management stuff. I'd appreciate any suggestions. Take a look at this?:

[GENERAL] PG vs MSSQL language comparison ?

Hi, I'm not into comparing which DBMS is better as we all know ... kind of ... well ... I'd like to find ressources to look up how one can do X in MSSQL when one knows how it is done in PG's SQL and the other way around. regards Andreas -- Sent via pgsql-general mailing list

Re: [GENERAL] PG vs MSSQL language comparison ?

On 26/05/2012 00:04, Andreas wrote: Hi, I'm not into comparing which DBMS is better as we all know ... kind of ... well ... I'd like to find ressources to look up how one can do X in MSSQL when one knows how it is done in PG's SQL and the other way around. regards Andreas Hi