[GENERAL] partitioning and dynamic query creation

Hello list, I'm currently thinking about a possibility to create a dynamic insert statement inside a trigger function to put the data in the correct partition. What am I talking about ? I want to put data dependant on a timestamp column ("datetime") in seperate partitions. Therefore I created th

Re: [GENERAL] problem with pg_standby

thanks Greg, yes, we want SELinux in enforcing mode. Thereby (and to ensure persistence) just chcon is the wrong way and * semanage fcontext -a -t postgresql_t '' * restorecon -vvFR is much better ;-) regards--GERD-- On Wednesday, August 04, 2010 07:56:56 am Greg Smith wrote: >

Re: [GENERAL] problem with pg_standby

Hello Greg, thanks for the hint, yes, SELinux caused the troubles. It complained about wrong filecontext while starting postgres via init-script. Filecontext was: var_lib_t and it should be: postgresql_t regards...GERD On Tuesday, August 03, 2010 11:54:45 pm Greg Smith wrote: > G

Re: [GENERAL] problem with pg_standby

call of pg_ctl as user postgres...?!?! Somebody an explanation ? kind regardsGERD On Tuesday, August 03, 2010 10:37:12 pm Gerd Koenig wrote: > Hello, > > we currently setup a standby database with archive_command sending the WALs > from master to standby. > This works

[GENERAL] problem with pg_standby

Hello, we currently setup a standby database with archive_command sending the WALs from master to standby. This works as expected, but the standby database doesn't restore the WALs from the given directory in recovery.conf and I have no idea why... recovery.conf: restore_comman

Re: [GENERAL] Trying to install ODBC driver on Windows XP notebook

Hi Phil, On Tuesday, June 22, 2010 10:19:33 pm Phil Jackson wrote: > I have latest Postgresql installed on a notebook and now trying to > install the driver which I have downloaded and run so that it is now > available in the ODBC Data Source Administrator > > This machine has CA security suite,

Re: [GENERAL] pgpool

Hi Geoffrey, you do not need to connect to your database directly, just connect to pgpool itself. e.g.: your database runs on port 5434, pgpool runs on port 5432 => * pgpool has to be configured in that way that it connects to the database on port 5434 * you/your app's should connect to the ser

Re: [GENERAL] no such file euc2004... while initdb 9.0Beta

Hi Shoaib, thanks for your hint it solved the problem just by "yum update postgresql-*" since I had the correct repository already ;-) regards...GERD... On Wednesday 05 May 2010 08:28:08 am Shoaib Mir wrote: > On Wed, May 5, 2010 at 4:05 PM, Gerd Koenig wrote: > > Hello,

[GENERAL] no such file euc2004... while initdb 9.0Beta

Hello, I've tried to install the latest 9.0Beta (Fedora12, pgdg repository), but with no success. "initdb" returns with an error described below. blub#> yum list postgres* Loaded plugins: refresh-packagekit Installed Packages postgresql.i3

Re: [GENERAL] Postgres 9.1 - Release Theme

Hi Dave, thanks for this funny post on April, 1st ;-) It's currently the highlight of my working day here regards..GERD.. On Thursday 01 April 2010 10:13:16 am Dave Page wrote: > Following a great deal of discussion, I'm pleased to announce that the > PostgreSQL Core team has decided that t

Re: [GENERAL] function to grant select on all tables in several schemas

Hello Andreas, thanks for your support, perfect :-) regardsGERD On Wednesday 20 January 2010 4:59:57 pm Andreas Kretschmer wrote: > Gerd Koenig wrote: > > Hello, > > > > I'm looking for a solution to grant select to a group to have "read-only" >

[GENERAL] function to grant select on all tables in several schemas

Hello, I'm looking for a solution to grant select to a group to have "read-only" group across all tables/views/.. in several schemas. I already found some workarounds and I decided to create a function to cover this topic. But calling this function throws the error: "" ERROR: column "´r´" does

Re: [GENERAL] high load on server

Hello Scott, thanks for answering. Scott Marlowe schrieb: 2009/4/3 Gerd König : Hello, since 2 days ago we're facing an increased load on our database server (opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB Ram). This high load stays the whole working day. How man cores? The server contains two

Re: [GENERAL] PostgreSQL CE?

Hi Steve, I know that EnterpriseDB offers 3 levels of certification. Perhaps one of them suits your needs..?!?! regards...:GERD:... steve.gnuli...@gmail.com schrieb: Just to know, if actually there's -or where- now, a PostgreSQL Certified Engineer program. I think that obtaining -if able- a