[GENERAL] PostgreSQL 9.1.10 release date?

I was wondering what is the expected release data for the next PostgreSQL patch - presumably 9.1.10? Although there is no documentation stating release timeframes I'd become accustomed to them being released in the first week of the month every other month. Thank You Rob -- View this message in

[GENERAL] pg_basebackup questions

Hi, PostgreSQL 9.1.6 Linux (SLES 11) i have a pg_basebackup job that is executed within a script. My command is: /postgresql/v91/bin/pg_basebackup -h 127.0.0.1 -D /postgresql/pg_backup/backupdir -Ft -Z 5 The result of this creates 2 files: base.tar and 16450.tar I understand that 16450 is th

[GENERAL] pgagent linux install issues

Hi, I'm attempting to install pgagent on SLES 11. So far I have downloaded the pgagent (3.3.0) to the server. Extracted using gunzip and untarred. I had the sysadmin install cmake 2.6 & wxGTK & wxGTK-devel using yast. When i run wx-config it shows version 2.8.10 When i attempt to install pgagent I

[GENERAL] PostgreSQL logging - restrict error messages

I'm running PostgreSQL 9.1.6 on Linux SLES 11 SP2 My question is, is it possible to restrict entries into the log bases on number of entries per second or avoid duplicate entries within the same second? Some background: My non default logging parameters in postgresql.conf #LOGGING log_directory

[GENERAL] pg_archivecleanup - clean up files with extensions

I'm running postgresql9.1.6 I would like to run pg_archivecleanup on wal files that have a .gz extension. I notice in the version 9.2 documentation there is an option for this. Is there an easy way to achieve the same thing in 9.1? Thanks, Rob -- View this message in context: http://postgres

Re: [GENERAL] oracle_fdw

Thanks Laurenz for your post... Some more info Oracle Server:Oracle 11g R2 (11.2.0.2.0) Client: 11.2 Was installed using Oracle Universal Installer I don't really want to post the full environment of the postmaster but basically I could see no entry in there for ORACLE_HOME or TNS_ADMIN, should

[GENERAL] oracle_fdw

Environment: PostgreSQL 9.1.6 SLES 11 SP2 Oracle_fdw 0.9.7 I am trying to implement the use of oracle_fdw. So far I have installed an oracle client on my postgres server. I can connect to the oracle environment from the postgres server (as postgres os user) by navigating to $ORACLE_HOME/bin then

[GENERAL] Sequence and Schema permissions information schema

PostgreSQL v9.1.6 Are sequence and schema permissions documented anywhere in the information schema. I've looked through documentation and the information_schema itself but have had no luck. I noticed in the 9.2 documentation there is a reference to 'sequences' in information_schema.usage_privileg

[GENERAL] PostgreSQL force create table / ignore constraints?

Version Postgresql 9.1.6 OS: SLES 11 64 bit Background: Our developers create database schema in development environment using PGAdmin (often using the GUI to generate the DDL). We always deploy to production using a script, a single .sql file which we execute via psql command line. This allows u

[GENERAL] PostgreSQL data loads - turn off WAL

My version: PostgreSQL v9.1.5 Version string: "PostgreSQL 9.1.5 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux) 4.3.4 [gcc-4_3-branch revision 152973], 64-bit" Basically my question is: Is there currently any way to avoid wal generation during data load for given tables and then have poi

[GENERAL] Postgresql Developer Privileges

Postgresql v9.1.4 SUSE Linux Enterprise Server SP2 In my agency we have application developers who do most of the database design/development themselves (not my choice) in the development environment but do not administer the database. Therefore I want developers to be able to create & drop tables

[GENERAL] postgres maintenance db

I'm using postgres 9.1.4 on Suse Linux Enterprise Server 11. After successful installation I by default have one database installed called postgres. I'm starting the process of migrating some database schemas off Oracle and mysql onto postgres but I want to understand how to best set up the "datab