[GENERAL] RAID and SSD configuration question

Hi I have a supermicro SYS-1028R-MCTR, LSI3108 integrated with SuperCap module (BTR-TFM8G-LSICVM02) - 2x300GB 10k spin drive, as raid 1 (OS) - 2x300GB 15k spin drive, as raid 1 (for xlog) - 2x200GB Intel DC S3710 SSD (for DB), as raid 1 So how is better for the SSDs: mdraid or controller's rai

[GENERAL] 9.3.9 ?

Hi all In the postgresql yum repo appeared the 9.3.9 and 9.4.4, but on the postgresql.org nothing about the new version. Where I can see the changelog? Thanks -- Levi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] POWA tool

On 22/08/2014 13:08, Birta Levente wrote: On 20/08/2014 23:27, Julien Rouhaud wrote: On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <mailto:spam_ea...@gmx.net>> wrote: Ramesh T schrieb am 20.08.2014 um 17:41: > Hello, > > when i ra

Re: [GENERAL] POWA tool

On 20/08/2014 23:27, Julien Rouhaud wrote: On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer > wrote: Ramesh T schrieb am 20.08.2014 um 17:41: > Hello, > > when i ran following query, > postgres=# SELECT * FROM pg_stat_s

Re: [GENERAL] Re: changing port numbers so pgbouncer can read geoserver and postgres

On 01/11/2013 15:39, si24 wrote: have you specified in your pgbouncer.ini auth_type and auth_file ? my auth_type is md5 and my auth_file is D:\Program Files\PostgreSQL\etc\userlist.txt And I think you really need to check pgbouncer log !!! I get a lot of this im my pgbouncer log 2013-11-01

Re: [GENERAL] Re: changing port numbers so pgbouncer can read geoserver and postgres

On 01/11/2013 15:39, si24 wrote: have you specified in your pgbouncer.ini auth_type and auth_file ? my auth_type is md5 and my auth_file is D:\Program Files\PostgreSQL\etc\userlist.txt And I think you really need to check pgbouncer log !!! I get a lot of this im my pgbouncer log 2013-11-01

Re: [GENERAL] changing port numbers so pgbouncer can read geoserver and postgres

On 01/11/2013 14:44, si24 wrote: I get this error in geoserver :Original exception error: Unable to obtain connection: Cannot create PoolableConnectionFactory (ERROR: client_login_timeout (server down)) when I change the store port number from 5432 to 6432 so that geoserver can use the pgbounc

Re: [GENERAL] Explanantion on pgbouncer please

On 01/11/2013 09:46, si24 wrote: So should I rather change the 6432 to 5432 like the postgresql port or 8080 like the geoserver tomcat port. Yes, you could do like this... but have to change psql server's port too ... to other than 5432... and tell pgbouncer to which port connect to postgresq

Re: [GENERAL] Explanantion on pgbouncer please

On 01/11/2013 09:07, si24 wrote: geoserver uses the same port number as tomcat does which 8080 as the moment should I change it to something else? postgres uses 5432(default port number to postgresql) and pgbouncer uses 6432(default port number given to pgbouncer) Am I missed something or you

Re: [GENERAL] Backup advice

On 08/04/2013 16:14, Johann Spies wrote: I would appreciate some advice from the experts on this list about the best backup strategy for my database. The setup: Size: might be about 200Gb The server uses a Tivoli backup client with daily backup At the moment There are pg_dumps for each database

Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

uncer. Thanks On 8 Jan 2013, at 3:13 PM, Birta Levente wrote: On 08/01/2013 08:40, a...@hsk.hk wrote: Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used "apt-get install pgbouncer", after configuring it, I can now connect to pg

Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

On 08/01/2013 08:40, a...@hsk.hk wrote: Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used "apt-get install pgbouncer", after configuring it, I can now connect to pgbouncer and can use all pgbouncer SHOW commands, however: Q1) Is versi

Re: [GENERAL] Problem starting PG-9.2 on non-default port

On 14/12/2012 16:37, Devrim Gündüz wrote: Hi, Is this an RPM installation? If so, you also need to change the port in the init script, too. Or if it's rhel/centos/sciencific like linux, you can specify in /etc/sysconfig/pgsql/postgresql-9.2: PGPORT=5433 Regards, Devrim "James B. Byrne"

Re: [GENERAL] PostgreSQL 8.4 download for RHEL6

On 05/06/2012 11:44, saimounika.j...@wipro.com wrote: Hello there, I have been searching for PostgreSQL 8.4+ version installable for RHEL6 – 64 bit. I worked with PostgreSQL8.3 installable earlier and did installation using postgresql-8.3.7-1-linux-x64.bin file. Now I am trying for the same fo

Re: [GENERAL] Postgresql 9.1 logging

On 04/01/2012 16:15, Andreas Kretschmer wrote: Birta Levente wrote: Hi all I use postgresql 9.1.2 on centos 6.2 and I want to use pgfouine, but in my log file appear #011, #015 ... characters and the pgfouine can't handle it. Can I configure the server or rsyslog to log without

[GENERAL] Postgresql 9.1 logging

Hi all I use postgresql 9.1.2 on centos 6.2 and I want to use pgfouine, but in my log file appear #011, #015 ... characters and the pgfouine can't handle it. Can I configure the server or rsyslog to log without these characters or I need filter separately? thanks Levi the log section from m

[GENERAL] archive_timeout runtime change

Hi I use postgrsql 9.1.1 and I want to change archive_timeout on a running server. My default archive_timeout is 1800s, and nightly I want to change to 3600s or more, but I get the following error message: set archive_timeout='3600'; ERROR: parameter "archive_timeout" cannot be changed now

[GENERAL] pg_dump and database size question

Hi, I have postgres 9.0.2 server with a 2.4GB database. After pg_dump of the database, the size increased with aprox 200MB ... why? I make some tests and the total_relation_size is increased, but the relation_size not. thanks Birta Levente -- Sent via pgsql-general mailing list (pgsql