[ADMIN] Problems with precompiled pgsql on mac

Hi Guys! I am trying to deploy an application together with postgresql. Therefore, i compiled postgres versions on Intel, G4 and G5. Mostly, this works perfectly. But on some machines, the installation was successful and postgres does not start. PostGres does not write any log. If i try to

Re: [ADMIN] Problems with precompiled pgsql on mac

Hi Shane, Peter Elmers wrote: Hi Guys! A bit more info would help - I am trying to deploy an application together with postgresql. Therefore, i compiled postgres versions on Intel, G4 and G5. Mostly, this works perfectly. But on some machines, the installation was successful and

Re: [ADMIN] Problems with precompiled pgsql on mac

09:38, Peter Elmers wrote: | I tailed the system.log directly after trying to start pg_ctl. Not a | single line about postgres. Also for the crashlog. | The Console.log is new to me. I will check this. also: you might want to try ktrace-ing the program and look at where exactly it barfs. I'd

Re: [ADMIN] Problems with precompiled pgsql on mac

uses postgres, too. But we are using another port and another user... Best Regards, Peter Am 27.03.2007 um 10:40 schrieb Peter Elmers: Hi Thomas, We already ktrace'd the programm on one of the failing machines and noticed nothing special. It looks nearly identical to the output of o

Re: [ADMIN] Problems with precompiled pgsql on mac

: max_connections = 40 shared_buffers=640kB Does anybody see any problems with theese settings? The amount of parallel connections should not be a big problem, because it is a dedicated database. Thanks Tom and best Regards, Peter Am 10.04.2007 um 16:30 schrieb Tom Lane: Peter Elmers <[EM

[ADMIN] Size of logfiles

Hi! I have searched the web and am sorry to say that i found nothing about the default behavior of the log files of postgres. Can anyone tell me when postgres will delete the logfiles or what postgres automatically do with them? Best regards, Peter ---(end of br

Re: [ADMIN] Size of logfiles

Hi Peter, Thank you for your fast reply. Yes, indeed i ment the normal error- logfiles. But if i start postgres with "-l" what duration does the logfiles have? Thanks, Peter Am 21.05.2007 um 16:42 schrieb Peter Eisentraut: Am Montag, 21. Mai 2007 15:38 schrieb Peter Elmer

Re: [ADMIN] Size of logfiles

21.05.2007 um 16:44 schrieb Chris Browne: [EMAIL PROTECTED] (Peter Elmers) writes: I have searched the web and am sorry to say that i found nothing about the default behavior of the log files of postgres. Can anyone tell me when postgres will delete the logfiles or what postgres automatically do with

Re: [ADMIN] Size of logfiles

Hi! Just for other users who might have the same question: With default settings, postgres writes 3 WAL files. Each of them has the size of 16 mb. They are located at the data directory within the subdirectory pg_xlog. Cheers, Peter Am 22.05.2007 um 21:22 schrieb Peter Elmers: Hi

[ADMIN] Several postgres installation on windows possible?

Hi Guys, I like to deploy a application based on postgres and i am pretty unsure whether it is possible to have several postgres installation on windows running in parallel. The normal installer comes up with a "change dialogue" if i try to install a second time or postgres is already insta

Re: [ADMIN] Several postgres installation on windows possible?

machine, provided on different port & data directory. Thanks, Umesh - Original Message - From: Peter Elmers To: pgsql-admin@postgresql.org Sent: Friday, July 13, 2007 6:52 PM Subject: [ADMIN] Several postgres installation on windows possible? Hi Guys, I like to deploy a applica

Re: [ADMIN] Several postgres installation on windows possible?

. then you can start both servers with C:\PostgresA>initdb -D / C:\PostgresB>initdb -D / Pls note that I haven't checked this thing..if you want me to check then gimme 1 day..I would check it & let you know.. Thanks, Umesh - Original Message - From: Peter Elmers To:

Re: [ADMIN] Several postgres installation on windows possible?

know.. Thanks, Umesh - Original Message - From: Peter Elmers To: Umesh Shastry Cc: pgsql-admin@postgresql.org Sent: Friday, July 13, 2007 7:04 PM Subject: Re: [ADMIN] Several postgres installation on windows possible? Hi Umesh, Thanks for the fast reply, but how can i install the second

Re: [ADMIN] Several postgres installation on windows possible?

er existed, registering the service, and all of the other things that would need to be done. Basically the second half of my blogged article. Would that work? Paul Peter Elmers wrote: Hi! I am still working on this problem. With the installer of postgres, it is not possible for me to instal

[ADMIN] adding a user with the permission to create trimmed users

Hi! I want to know whether there exist the possibility to create a user who has the permission to create users with preset limited permissions. In detail: I do not want that the admin user (a seperate limited one for the customer) is able to create full admin users or adequate ones. Thank

Re: [ADMIN] adding a user with the permission to create trimmed users

Hi Ben! Thanks for your answer! It hits the spot. Peter Am 17.08.2007 um 19:28 schrieb Ben Kim: I want to know whether there exist the possibility to create a user who has the permission to create users with preset limited permissions. In detail: I do not want that the admin user (a sep