Re: [ADMIN] Help needed to set the Optimal Value for shared_buffers.
Kishore B <[EMAIL PROTECTED]> writes: > 1) I am new to administering postgresql. When I was wandering > through the configuration files for the PostgreSQL, I observed the > 'fsync' file. This file is almost identical to the postgresql.conf > file, but with differing values for parameters and some new / deleted > parameters when compared with the postgresql.conf file. What is the > file for? Does it have any specific importance to be taken care of? There is no such file in any standard distribution of Postgres. I guess that some previous admin of your machine made it as a copy of one set of config parameters that he was experimenting with. > 2) What is the optimall value for shared_buffers parameter to be set > for a huge database that contains a table with upto '4GB' data. Opinions vary, but I would say that 1-5 buffers is a reasonable range to be working in. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] Help needed Please !!!!!incremental backups possible in
On Fri, 19 Dec 2003, Priya G wrote: > Hi all, > > Is Incremental backups possible in Postgres 7.3 or 7.4 Nope. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] help needed!!!
scott.marlowe writes: > Sure, basically, modern versions of the client library can talk to older > versions of the database backend up to a point (i.e. the 7.4 library in > beta can go back to 6.5 or 6.4 or something like that. Support for 6.2 or > thereabouts was recently dropped.) > > However, going the other way, old connect libs and newer postgresql back > end versions can result in an issue where the old lib can't connect. This is not correct. Old client libraries can connect to new servers. In any case, the error message in case of a version mismatch is not "invalid length of startup packet", so this whole discussion is not the solution to the original question. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] help needed!!!
Sure, basically, modern versions of the client library can talk to older versions of the database backend up to a point (i.e. the 7.4 library in beta can go back to 6.5 or 6.4 or something like that. Support for 6.2 or thereabouts was recently dropped.) However, going the other way, old connect libs and newer postgresql back end versions can result in an issue where the old lib can't connect. the normal solution is to link to / use the newer connection libraries that come with a late model pgsql (7.3, 7.4 etc...) On Tue, 23 Sep 2003, Priya G wrote: > > Since I am a novice can you explain more about this version mismatch? > > >From: Bruce Momjian <[EMAIL PROTECTED]> > >To: Priya G <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: [ADMIN] help needed!!! > >Date: Mon, 22 Sep 2003 14:46:27 -0400 (EDT) > > > >Priya G wrote: > >[ text/html is unsupported, treating like TEXT/PLAIN ] > > > > > > > > Hi all, > > > > > > The following message was found in the postgres > >logpostgres[20563]: [73256] > > > > > > FATAL 1: invalid length of startup packet > > > > > > > what does this mean? > > > > > > Thanks >href="http://g.msn.com/8HMBENUS/2746??PS=";>Add MSN 8 Internet Software to > >your existing Internet access and enjoy patented spam protection and more. > >Sign up now! > > > >Odds are you have a mismatch between the client version and the server > >version. > > > >-- > > Bruce Momjian| http://candle.pha.pa.us > > [EMAIL PROTECTED] | (610) 359-1001 > > + If your life is a hard drive, | 13 Roberts Road > > + Christ can be your backup.| Newtown Square, Pennsylvania > >19073 > > _ > Instant message with integrated webcam using MSN Messenger 6.0. Try it now > FREE! http://msnmessenger-download.com > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] help needed!!!
Since I am a novice can you explain more about this version mismatch? From: Bruce Momjian <[EMAIL PROTECTED]> To: Priya G <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed!!! Date: Mon, 22 Sep 2003 14:46:27 -0400 (EDT) Priya G wrote: [ text/html is unsupported, treating like TEXT/PLAIN ] > > Hi all, > > The following message was found in the postgres logpostgres[20563]: [73256] FATAL 1: invalid length of startup packet > what does this mean? > > Thanks http://g.msn.com/8HMBENUS/2746??PS=";>Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! Odds are you have a mismatch between the client version and the server version. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 _ Instant message with integrated webcam using MSN Messenger 6.0. Try it now FREE! http://msnmessenger-download.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] help needed!!!
Priya G wrote: [ text/html is unsupported, treating like TEXT/PLAIN ] > > Hi all, > > The following message was found in the postgres logpostgres[20563]: > [73256] FATAL 1: invalid length of startup packet > what does this mean? > > Thanks href="http://g.msn.com/8HMBENUS/2746??PS=";>Add MSN 8 Internet Software to your > existing Internet access and enjoy patented spam protection and more. Sign up now! > Odds are you have a mismatch between the client version and the server version. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [ADMIN] help needed for performance tuning
it is a simple select from the table .The table has only 25 rows.it took 13 seconds for the query to give result.I did a vacumm every 5 mintues.Now it is fast.Now it takes only 1 sec select * from a ; Thanks.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 9:49 AM To: Priya Nair Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed for performance tuning How is your query written, and are you dealing with any referential interegrity? Corey "Priya Nair" <[EMAIL PROTECTED]>To: <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: [ADMIN] help needed for performance tuning gresql.org 07/31/03 02:36 PM Hi It takes 10 -12 seconds for a select of a table with 25 rows.One of the filed of this table is getting updated every 3 minutes..Do you think vacuum of the table every 10 min will help to speed this up? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] help needed for performance tuning
How is your query written, and are you dealing with any referential interegrity? Corey "Priya Nair" <[EMAIL PROTECTED]>To: <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: [ADMIN] help needed for performance tuning gresql.org 07/31/03 02:36 PM Hi It takes 10 -12 seconds for a select of a table with 25 rows.One of the filed of this table is getting updated every 3 minutes..Do you think vacuum of the table every 10 min will help to speed this up? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [ADMIN] Help needed
try to start the postgres daemon /etc/init.d/postgres start -Original Message-From: John McMaster [mailto:[EMAIL PROTECTED]]Sent: segunda-feira, 10 de junho de 2002 19:55To: [EMAIL PROTECTED]Subject: [ADMIN] Help needed Hi I keep getting the following error when I try to connect the te db. "Warning: Unable to connect to PostgreSQL server: (null) in /var/www/html/mysite/tv_lib/db_mysql.php on line 48Database error: Link-ID == false, pconnect failedPostgreSQL Error: 0 ()Session halted. Any ideas on how I fix this. It started after I rebooted my linux system. It was working before I rebooted. John McMaster