Re: [ADMIN] phpPgAdmin configuration

its configuration? I run Fedora & have encountered similar problems on every upgrade (shame on me, I forget about it until the next upgrade...) Barbara > I installed phpPgAdmin on my red hat box in the /var/www/html directory. > I edited the pg_hba.conf file as many tutorials stated

[ADMIN] Converting from 7.4.19 To 8.3.1 & want to use autovacuum

ze to our entire database. autovacuum=true track_counts=ture log_autovacuum_min_duration=1000ms autovacuum_max_workers=3(default) autovacuum_naptime=60 autovacuum_vacuum_threshold=50(default) Are the above settings all we need to start auto vacuuming? -- Regards, Barbara Stephenson EDI Speci

Re: [ADMIN] Converting from 7.4.19 To 8.3.1 & want to use autovacuum

Oh I have to look at the other parameters. Once the database is up and it's not vacuuming like we want how do we make changes to the conf file while the database is running? Some signal? Guillaume Lelarge wrote: > Hi, > > Barbara Stephenson a écrit : > > We are new about au

[ADMIN] open source ERD for postgresql database

I would like to use an ERD tool for postgres and it be open source. Any suggestions? -- Regards, Barbara Stephenson EDI Specialist/Programmer Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30507 tel: (678)989-3020 fax: (404)935-6171 [EMAIL PROTECTED

[ADMIN] Recommend dba maintenance tasks on a regular bases

s = 3 autovacuum_naptime = 1min autovacuum_vacuum_threshold = 50 autovacuum_vacuum_scale_factor = 0.2 autovacuum_analyze_scale_factor = 0.1 3- rotate data logs -- Regards, Barbara Stephenson EDI Specialist/Programmer Turbo, division of Ozburn-Hessey Logistics 2251 Jesse J

Re: [ADMIN] open source ERD for postgresql database

endly. However, I know some do have a 30 day trial. Barbara Anibal David Acosta wrote: > MICRO-OLAP Database designer for postgres is a great tool. > > > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] En nombre de Carol Walter > Enviado el: lunes

Re: [ADMIN] Recommend dba maintenance tasks on a regular bases

slots are required to track all free space. Current limits are: 153600 page slots, 1000 relations, using 965 kB. Jeff Frost wrote: > On Fri, 12 Sep 2008, Barbara Stephenson wrote: > > 1- pg_dump - binary dump every midday and nightly > > 2 - auto vacuum > > 3- rotate data logs &g

Re: [ADMIN] open source ERD for postgresql database

ombre de Carol Walter > Enviado el: lunes, 15 de septiembre de 2008 02:58 p.m. > Para: Thomas Jacob > CC: Barbara Stephenson; pgsql-admin@postgresql.org > Asunto: Re: [ADMIN] open source ERD for postgresql database > > This sort of depends on what you want to do with the ERD. If

[ADMIN] tuning our database by increasing shared buffer

r 128 since we have more than doubled the # of connections? max_prepared_transaction is set at default of 5 which is says if we use it to set it to max_connection. Or leaving those 2 max parameters as default would be ok? -- Regards, Barbara Stephenson EDI Specialist/Programmer Turbo, divisi

Re: [ADMIN] tuning our database by increasing shared buffer

Thank ypu! Tom Lane wrote: Barbara Stephenson writes: We will be consolidating from 4 databases to 2 and want to make sure that these parameters are the only ones that need changing. Please advise. Current Future