Thread

1. postmaster confiugration and hardware configuration

   kopra <kopraworkshop@telkom.net> — 1999-02-06T09:00:26Z

   Hi...
   
   I'm newbie, and confuse on configuration....
   
   I already installed postgresql 7.0.3 on Compaq Proliant ML 350 - Intel
   Pentium III 600 - RAM 128 MB.
   Operating system is linux on distribution SuSE 6.4
   This server only running database itself. Directory '/data' is independent
   partition and size is 3GB
   This database is used for application with intensive querries and around 30
   connection at a time.
   Postmaster configuration is default.
   
   Problem comes up with decrease performace of query result when connection
   reached around 30, long wait situatioon is like you can make a cup of coffee
   on the kitchen...around 12 second. The bad news is...broken pipe() and all
   connection to postgresql is gone...
   
   The application using 'begin...commit' method.
   
   Any suggestion to increase performance of my postgresql....at least great
   configuration for postmaster and hardware...?
   Pleasse.... :-)
   
   Regards,
   Eko Pranoto
   Database Administrator of Health Care Information System Project
   Rumah Sakit Pertamina Jaya
   Indonesia
   
   
   

2. pgaccess on Win9x

   Bill Barnes <kgbsoft@yahoo.com> — 2001-03-04T22:50:20Z

   Hi Y'all:
   
   Unzipped pgaccess to C:\.
   Have TclPro 1.4 at c:\Program Files\TclPro1.4
   Executing C:\pgaccess\main.tcl I get:
   couldn't load library "libpgtcl.dll": this library or
   a dependent library could not be found in library path
   while executing
   "load libpgtcl[info sharedlibextension]"
   [procedure "main" line 3]
   invoked from within
   "main $argc $argv"
    [file "C:\PGACCESS\MAIN.TCL" line 249]
   
   Copied libpgtcl83.dll-7.0 to \windows\system as
   libpgtcl.dll.
   
   Appreciate your help.
   -bill
   
   
   __________________________________________________
   Do You Yahoo!?
   Get email at your own domain with Yahoo! Mail. 
   http://personal.mail.yahoo.com/
   
   

3. JDBC timestamps with timezones

   David Wall <d.wall@computer.org> — 2001-03-04T23:32:35Z

   In reading about how Timestamps are stored in Postgresql 7.1 (they are
   stored in GMT based on the TZ in effect on the server running the backend),
   I was wondering how this impacts JDBC.
   
   We want to be able to retrieve timestamps from the database and then show
   them to invididual users based on their specified timezone which we know in
   advance.  With Java, I can take a Date/Calendar and get the current time
   using a specified TimeZone object.  Does the JDBC then know to always
   retrieve the timestamp and keep it internally as GMT, too so that all the
   time zone stuff will work?
   
   Thanks,
   David
   
   
   

4. Re: JDBC timestamps with timezones

   Barry Lind <barry@xythos.com> — 2001-03-05T00:01:53Z

   You shouldn't have any problems with the 7.1 drivers doing what you 
   need.  The 7.1 jdbc driver should correctly handle timezones.  The 7.0 
   drivers didn't work correctly if the client timezone and server 
   timezones were different.
   
   Since 7.1 is still in beta, please test it out and report any bugs you find.
   
   thanks,
   --Barry
   
   
   
   David Wall wrote:
   
   > In reading about how Timestamps are stored in Postgresql 7.1 (they are
   > stored in GMT based on the TZ in effect on the server running the backend),
   > I was wondering how this impacts JDBC.
   > 
   > We want to be able to retrieve timestamps from the database and then show
   > them to invididual users based on their specified timezone which we know in
   > advance.  With Java, I can take a Date/Calendar and get the current time
   > using a specified TimeZone object.  Does the JDBC then know to always
   > retrieve the timestamp and keep it internally as GMT, too so that all the
   > time zone stuff will work?
   > 
   > Thanks,
   > David
   > 
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 3: if posting/reading through Usenet, please send an appropriate
   > subscribe-nomail command to majordomo@postgresql.org so that your
   > message can get through to the mailing list cleanly
   
   
   

5. Re: postmaster confiugration and hardware configuration

   Gavin Sherry <swm@linuxworld.com.au> — 2001-03-05T09:26:40Z

   Eko,
   
   On Sat, 6 Feb 1999, KoPra Workshop wrote:
   
   > Any suggestion to increase performance of my postgresql....at least great
   > configuration for postmaster and hardware...?
   > Pleasse.... :-)
   
   It is hard to tell with the information you are giving, but perhaps you
   are hitting the default limit for the number of simultaneous backends 
   (32). You can increase this by passing -N <number> to postmaster at
   startup from the command line (naturally, this should be greater than 32,
   perhaps 64). Increasing the number of backends necessitates the increasing
   of the number of buffers.
   
   More info in the postgres documentation.
   
   > 
   > Regards,
   > Eko Pranoto
   > Database Administrator of Health Care Information System Project
   > Rumah Sakit Pertamina Jaya
   > Indonesia
   
   
   Gavin Sherry
   Alcove Systems Engineering.
   
   
   
   

6. Re: postmaster confiugration and hardware configuration

   Anthony E . Greene <agreene@pobox.com> — 2001-03-05T13:47:07Z

   On Sat, 06 Feb 1999 04:00:26 KoPra Workshop wrote:
   >I'm newbie, and confuse on configuration....
   
   Your system clock is not correct.
   
   -- 
   Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
   PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
   Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
   Linux. The choice of a GNU Generation. <http://www.linux.org/>