[GENERAL] a few Questions about quoted variables in psql

een? \set foo bar \echo :foo test ==> bar test (but there is a space in between) \echo :foo||test ==> this does not work (I want bartest) Is it somehow possible to do this? Thanks for your help! Leo -- +++ Jetzt WLAN-Router für alle DSL-Einsteiger und Wechsler +++

[GENERAL] Does pglogical support PG 9.4.5?

Hi all, I am test pglogical on PG 9.4.5, but I am not successfully even if I install the latest version "postgresql94-pglogical-1.0.1-2". Is there any one running pglogical on PG 9.4.5 successfully? I describe my operation step, please help me to trouble shooting? provider node: 1

Re: [GENERAL] How to recovery failed master after failover

I wonder how to quickly recovery failed master? If I directly startup the failed master as slave ( assign proper parameter), is there any problem? For example, I don't do any copy operation in script of recovery_1st_stage_command and recovery_2st_stage_command. According to this document: https://

Re: [GENERAL] How to recovery failed master after failover

resql.conf. Is there anyone use this parameter? Leo -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-recovery-failed-master-after-failover-tp5794524p5794720.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-gener

[GENERAL] There is bug in PCS 0.9.26: configure pacemaker resource agent for PG stream replication

Hi all, I just complete my HA configuration on Redhat 6.4 enterprise: Clusterware: Pacemaker 1.1.8 ( CMAN .0.12.1, corosync 1.4.1 ) Resource manager: PCS 0.9.26 PostgreSQL 9.3.3.1 Detailed configuration follow: http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster#Post

[GENERAL] pg_start_backup: file has vanished from pg_subtrans/

re what to believe, either - my backup was invalid and I have to take measures to prevent this (and file a bug report) - I can ignore this *and* can safely exclude pg_trans/ from my backups. - there is some other workaround... -- Leo Baltus -- Sent via pgsql-general mailing list (pgs

Re: [GENERAL] pg_start_backup: file has vanished from pg_subtrans/

Op 08/08/2015 om 14:24:00 -0400, schreef David Steele: > On 8/7/15 7:01 AM, Leo Baltus wrote: > >While backing up some postgresql-8.4.2 instances using > >pg_start_backup()/pg_stop_backup() > > > >We noticed that sometimes rsync complains: > > > >file has va

[GENERAL] psql --quiet

postgresql-9.4.5 When running pg_stop_backup() psql outputs on stderr: NOTICE: pg_stop_backup complete, all required WAL segments have been archived --quiet does not seem to suppress it, what does? I really hate to redirect stderr to /dev/null. -- Leo Baltus, internetbeheerder NPO ICT

[GENERAL] psql --quiet

postgresql-9.4.5 When running pg_stop_backup() psql outputs on stderr: NOTICE: pg_stop_backup complete, all required WAL segments have been archived --quiet does not seem to suppress it, what does? I really hate to redirect stderr to /dev/null. -- Leo Baltus, internetbeheerder NPO ICT

Re: [GENERAL] psql --quiet

Op 27/10/2015 om 15:32:46 +0100, schreef David Steele: > On 10/27/15 3:16 PM, Leo Baltus wrote: > >postgresql-9.4.5 > > > >When running pg_stop_backup() psql outputs on stderr: > > > >NOTICE: pg_stop_backup complete, all required WAL segments have been > >a

[GENERAL] postgresql ask for someparameters

hello everyone: i found database crashed,i checked log,it indicated error: CONTEXT: xlog redo insert: rel 48777166/22362/48778276; tid 2/2 i wanted to know:what's meaning of real? and what's meaning of 48777166/22362/48778276 ?what's meaning of tid 2/2 ? please tell m

[GENERAL] how to calculate or know seq_scan scan how many blocks every time

hello: i know oracle scatter read blocks,can set db_file_multiblock_read_count every time, i see postgres,it exists scatter read blocks,it is seq_scan,how to know scan many bloks every time? -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-

[GENERAL] Re: how to calculate or know seq_scan scan how many blocks every time

hello everyone who can explain it ?thanks! -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-seq-scan-scan-how-many-blocks-every-time-tp5717892p5718082.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via

[GENERAL] what happens when concurrent index create

i read documents,i find it that concurrent index create don't lock write.but need scan table twice.it explain is following as: It scans the table once to initially build the index, then makes a second pass to look for things added after the first pass. please explain 1. what happens when concu

[GENERAL] postgresql standby using pg_archivecleanup don't work

i have one parimary ,two standby. one standby using stream replication connect to primary.another standby using basebackup,then recovery database --cp archivelog from primary using crontab.i want to delete old archivelog from standby.but configure pg_archivecleanup don't work,meantime no error in p

[GENERAL] postgresql log indicate too many execute S_2:COMMIT

Hello: I test postgresql database performance recently,i set log_min_duration_statement=1000; i monitor pg_log file,i find too many execue S_2:commit 10.0.44.21:30170:2012-04-28 11:38:46.340 CSTLOG: duration: 1050.679 ms execute S_2: COMMIT 10.0.44.21:30208:2012-04-28 11:38:46.340 CSTLOG: d

Re: [GENERAL] postgresql standby using pg_archivecleanup don't work

hello: i try it,but it nothing in pg_log.it still don't work! -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-standby-using-pg-archivecleanup-don-t-work-tp5669340p5672191.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

Re: [GENERAL] postgresql log indicate too many execute S_2:COMMIT

my postgres version is 9.1.2.my machine is dell R710.3000 sessions connect to database concurrently,then doing some insert,delete,update. your meaning my database bottleneck is disk io slowly.i use local disk.i know transaction log need to wirte to disk. thanks.i will monitor it. -

[GENERAL] How to allow non-local to postgreSQL

Good Day     I Just want to ask on how to allow a non-local in PostgreSQL without adding it in pg-hba.conf   I just want to view a desktop application on Web, yes it works, but you need to allow those I.P. addresses that will gonna connect to postgreSQL. What I want is everyone in the ne

[GENERAL] RH7.3 / PGSQL7.4.1 binary distribution

Hi! I tried to find the binary distribution of Postgresql 7.4.1 for RedHat 7.3. The FTP directory was empty so I Googled for it and found some RPMs at http://developer.postgresql.org/ftpsite/binary/v7.4.1/redhat/redhat-7.3/ . However, when I tried to dowload them I received a "403 Forbidden" respo

[GENERAL] create a text file from postgres (like Oracle UTL_FILE package)

Hi, Anybody know/have functions or package to create text file from postgres function? I want to execute a function to take some fields from a table and save it in a text file (or xml format). I need function like: createfile(filename); appendtofile(filename,text); etc. thanks

Re: [GENERAL] create a text file from postgres (like Oracle UTL_FILE package)

rted. > > Also, I'd recommend continuing to post and not > merely emailing me > directly to keep more eyes on your problem. > > -tfo > > -- > Thomas F. O'Connell > Co-Founder, Information Architect > Sitening, LLC > http://www.sitening.com/ > 110

[GENERAL] Update from select??

Hi all, I need do a update from t1 set col='P' where int_art = (SELECT int_art from t2 ). I know that thios sentence is not correct but I'd like do the update for everethigs rows that return the select. Is it posible? Tk very much Jose Antonio -Mensaje original- De: [EMAIL PROTE

[GENERAL] update innside transactions?

Hi! I have a doubt, I have somethigs same this... init transaction update from tabla1 set estado=1 where art=0; update from tabla1 set estado=estado+1 where estado=1 final trasaction The second update take the first updates if we are in the same transaction? Tk -