Re: [GENERAL] FOREIGN TABLE with dblink

Hi Shigeru, thank you for responding. This is going to be a great feature! Regards, Jasmin 2011/6/29 Shigeru Hanada > Hi Jasmin, > > (2011/06/16 19:40), Jasmin Dizdarevic wrote: > > Hi, > > > > is there any way to use the new foreign table feature with dblink? &g

[GENERAL] FOREIGN TABLE with dblink

Hi, is there any way to use the new foreign table feature with dblink? That's almost clear to me: CREATE FOREIGN DATA WRAPPER pgsql90; CREATE SERVER srvlocal90 FOREIGN DATA WRAPPER pgsql90 OPTIONS (hostaddr '127.0.0.1', dbname 'lotty'); CREATE USER MAPPING FOR pgsql SERVER srvlocal90 OPTIONS (u

Re: [GENERAL] " FATAL: no pg_hba.conf entry for host" messages...

Hi, looks like a missing entry in pg_hba.conf for the requesting host. Look here: http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html greets jasmin 2011/5/19 Shafi DBA > Folks, > > > > Customer is getting below messa

Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0xc35c

@ALL: Isn't it possible and wise to include an (optional) encoder in pgsql? we're importing a lot of data from textfiles, which are not utf-8. we always have to change the encoding in another tool before using COPY. 2011/2/28 Craig Ringer > On 27/02/11 20:47, AI Rumman wrote: > > I am getting

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

w Sullivan > On Mon, Feb 28, 2011 at 12:13:32AM +0100, Jasmin Dizdarevic wrote: > > My idea was the one, that john described: DML and DDL are done on the > small > > box and reporting on the "big mama" with streaming replication and hot > > stand-by enabled. the

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

Thank you for your detailed information about HA and LB. First of all it's a pitty that there is no built-in feature for LB+HA (both of them, simultaneous). In my eyes, the pgpool2/3-solution has to much disadvantages and restrictions. My idea was the one, that john described: DML and DDL are done

[GENERAL] PG on two nodes with shared disk ocfs2 & drbd

Hi, I have to build a load balanced pg-cluster and I wanted to ask you, if this configuration would work: A drbd disk in dual primary mode with ocfs2-filesystem. Will there be any conflicts if using the shared volume as PGDATA directory? R+W is a required feature for this cluster. Thank you Ja