Re: [GENERAL] Postgres upgrade from 9.4.9 to 9.6 using pg_upgrade error

On Wed, Oct 19, 2016 at 6:15 AM, Ashish Chauhan wrote: > *2016-10-18 22:11:30 UTC [13107-1] FATAL: database files are incompatible > with server* > > *2016-10-18 22:11:30 UTC [13107-2] DETAIL: The data directory was > initialized by PostgreSQL version 9.6, which is

Re: [GENERAL] PostgreSQL DB Replication

What's the output when you try to login? Have your slave configured as a standby server ? On Mon, Aug 25, 2014 at 12:46 PM, Rajesh K rajesh...@yahoo.in wrote: Dear Sir, I have planned to configure PostgreSQL 9.2.4 database Master and Slave replication on Redhat Linux Server 6.As per the

Re: [GENERAL] Detect streaming replication failure

you can run select * from pg_stat_replication on master to check all the salve stats. On Fri, Jul 18, 2014 at 6:50 AM, Lists li...@benjamindsmith.com wrote: For reference: https://wiki.postgresql.org/wiki/Streaming_Replication Assume a master - slave streaming replication configuration,

Re: [GENERAL] Make basebackup use low level API and rsync

PostgreSQL 9.2.4 On Tue, Apr 22, 2014 at 1:58 PM, Michael Paquier michael.paqu...@gmail.comwrote: On Tue, Apr 22, 2014 at 1:28 PM, wd w...@wdicc.com wrote: I'v try to make a base backup use pg_start_backup, pg_stop_backup and rsync, but failed. After run select pg_start_backup('label

[GENERAL] Make basebackup use low level API and rsync

hi, I'v try to make a base backup use pg_start_backup, pg_stop_backup and rsync, but failed. After run select pg_start_backup('label') on db server, I run rsync on backup server, and got some errors like 'file has vanished: ', think this should be ok since it's documented in the manual. Then

[GENERAL] Exclude pg_log directory when running pg_basebackup?

I found there is no option to disable sync for pg_log in pg_basebackup, maybe there should be one option to disalbe it?

Re: [GENERAL] unexpected pageaddr error in db log

On Thu, Dec 19, 2013 at 11:56 PM, bricklen brick...@gmail.com wrote: On Thu, Dec 19, 2013 at 1:27 AM, wd w...@wdicc.com wrote: On Thu, Dec 19, 2013 at 2:24 PM, Amit Langote amitlangot...@gmail.comwrote: unexpected pageaddr log entry in this case means the standby reached the end

Re: [GENERAL] unexpected pageaddr error in db log

On Thu, Dec 19, 2013 at 2:24 PM, Amit Langote amitlangot...@gmail.comwrote: unexpected pageaddr log entry in this case means the standby reached the end of existing WAL. So, just before connecting to walsender for streaming replication, it logs this. Thanks for your reply. So this means I

[GENERAL] unexpected pageaddr error in db log

hi, We have upgrade our database from PostgreSQL 9.2.4 to 9.3.2, use dump restore in a fresh db created by initdb. Then use pg_basebackup created 2 slave db, the error occur when start the database. db1 [2013-12-19 04:00:56.882 CST 17956 52b1fef8.4624 1 0]LOG: database system was

Re: [GENERAL] Breaking up a PostgreSQL COPY command into chunks?

Try this, max_standby_archive_delay = 600s# max delay before canceling queries # when reading WAL from archive; # -1 allows indefinite delay max_standby_streaming_delay = 600s # max delay before canceling

Re: [GENERAL] Recovery.conf and PITR

Try add these settings, pause_at_recovery_target=true recovery_target_inclusive=false On Fri, Aug 9, 2013 at 4:09 PM, ascot.m...@gmail.com ascot.m...@gmail.comwrote: Hi, I am trying PITR in a test machine (same PG version 9.2.4 same O/S Ubuntu 12.04 64 bit). All archived WAL files are

Re: [GENERAL] Postgres 8.4 stopped working---Please urgent help needed

On Sun, Jun 9, 2013 at 6:04 AM, g.si...@utwente.nl wrote: Hi All, I have a problem with PostgreSQL 8.4. It was working perfectly fine but after the restart (within a couple of minutes) of my system whenever I login to PostgreSQL 8.4 (localhost:5432) it gives error as under: *Server

Re: [GENERAL] Create a DBLink from PostrgeSQL 9.2 to Oracle 11g

You can try http://oracle-fdw.projects.postgresql.org/ On Wed, Apr 10, 2013 at 12:07 AM, kiran kiran.peddire...@cmegroup.comwrote: Hello, I am looking for an example on creating a DBLink from PostrgeSQL 9.2 to Oracle 11g. I tried the below link and for some reason the ODBC_Link

Re: [GENERAL] streaming replication question

On Fri, Mar 22, 2013 at 11:27 AM, Roberto Scattini roberto.scatt...@gmail.com wrote: On Thursday, March 21, 2013, wd w...@wdicc.com wrote: You can combine warm standby and streaming, we do this in our product database. When the standby is to far from the master, the slave will try to use

Re: [GENERAL] streaming replication question

You can combine warm standby and streaming, we do this in our product database. When the standby is to far from the master, the slave will try to use restore_command to restore the database(warm standby), when the standby catch up the master, the steaming will working again. BTW: we use

Re: [GENERAL] Weird explain output

Thanks for your reply. On Mon, Feb 4, 2013 at 3:48 PM, Tom Lane t...@sss.pgh.pa.us wrote: You're worrying about the wrong thing entirely. The right thing to be worrying about is why are some of those row estimates off by four orders of magnitude, and what you can do to fix that. The

[GENERAL] Weird explain output

I have a long SQL with many join, the explain analyse output like - Hash Left Join (cost=197749705.15..5320438982425.18 rows=5245599776015 width=7542) (actual time=674.634..2645.293 rows=4568 loops=1) Hash Cond: (p.id = ps.partner_id) - Merge Join

Re: [GENERAL] Getting Mysql data into Postgres: least painful methods?

You can search from google, https://www.google.com/search?q=mysql2pgie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-a On Sat, Jan 12, 2013 at 7:54 AM, Ken Tanzer ken.tan...@gmail.com wrote: I'm wondering if anyone can point me towards a good method for moving mysql data into

[GENERAL] Group by bug?

hi, wd_test=# \d t1 Table public.t1 Column | Type |Modifiers +-+- id | integer | not null default nextval('t1_id_seq'::regclass) tag| text| wd_test=# select * from t1;

Re: [GENERAL] Group by bug?

Sorry, forget to say, PostgreSQL 9.2.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3), 64-bit psql (9.2.2) On Fri, Dec 28, 2012 at 3:24 PM, wd w...@wdicc.com wrote: hi, wd_test=# \d t1 Table public.t1 Column | Type

Re: [GENERAL] Group by bug?

Oh, I see, thanks for your quick reply. On Fri, Dec 28, 2012 at 3:47 PM, Jov zhao6...@gmail.com wrote: 2012/12/28 wd w...@wdicc.com hi, wd_test=# \d t1 Table public.t1 Column | Type |Modifiers

Re: [GENERAL] Corrupt indexes on slave when using pg_bulkload on master

We encounter the same problem, and have to change to use copy command On Wed, Dec 5, 2012 at 9:17 PM, James Cowell jcow...@btinternet.com wrote: I'm using pg_bulkload to load large amounts of CSV data into a postgres database hourly. This database is replicated to a second node. Whenever

Re: [GENERAL] Looking for cooperators

Seems they fork from postgres, pgadmin and rename them to highgo and hgadmin, but didn't announce this anywhere. (Merlln, sorry for the individual mail) On Tue, Dec 11, 2012 at 10:31 PM, Merlin Moncure mmonc...@gmail.com wrote: On Mon, Dec 10, 2012 at 7:02 PM, Fan, Yi fany...@gmail.com wrote:

Re: [GENERAL] How to find which query a waiting query waiting for?

I know how to do this, thanks. On Fri, Dec 7, 2012 at 11:09 PM, Fabrízio de Royes Mello fabriziome...@gmail.com wrote: On Fri, Dec 7, 2012 at 1:02 PM, wd w...@wdicc.com wrote: hi, From pg_stat_activity I can find a query is at waiting state, and from pg_locks and pg_class can find which

[GENERAL] How to find which query a waiting query waiting for?

hi, From pg_stat_activity I can find a query is at waiting state, and from pg_locks and pg_class can find which relation the query is waiting for, But how to find witch query is lock the relation?

[GENERAL] Is there a working pgsql-fdw for PostgreSQL 9.2?

Only found one http://interdbconnect.sourceforge.net/pgsql_fdw/pgsql_fdw-en.html working for PostgreSQL 9.1.

Re: [GENERAL] Restore postgres to specific time

I can't connect to postgres at that time. On Mon, Nov 26, 2012 at 4:33 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: wd wrote: Logs are something like this: [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery has paused [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247

Re: [GENERAL] Restore postgres to specific time

On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: wd wrote: Logs are something like this: [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery has paused [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT: Execute

Re: [GENERAL] Restore postgres to specific time

On Tue, Nov 27, 2012 at 8:27 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner kgri...@mail.com wrote: Jeff Janes wrote: FATAL: requested recovery stop point is before consistent recovery point I don't understand why are you not getting this

Re: [GENERAL] Restore postgres to specific time

: On Fri, Nov 23, 2012 at 8:59 AM, wd w...@wdicc.com wrote: Thanks for your reply, the logs are something like bellow，postgres will restore every wal log I put in the xlog directory，and then continues waiting for next wal log. The postgres version is 9.1.6. [2012-11-22 18:49:24.175 CST

Re: [GENERAL] Restore postgres to specific time

On Sun, Nov 25, 2012 at 4:25 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Sat, Nov 24, 2012 at 6:00 AM, wd w...@wdicc.com wrote: Yes, you are right, after set the two command, the recovery will stop at that time. But there is an other question, how to make this recovered Postgres can

[GENERAL] Restore postgres to specific time

hi, I've try to restore Postgres to a specific time but failed. The recovery.conf as bellow restore_command='cp /t/xlog/%f %p' recovery_target_time='2012-11-22 5:01:09 CST' pause_at_recovery_target=true recovery_target_inclusive=false The basebackup was made at 2012-11-22 3:10 CST, I've copy

Re: [GENERAL] Restore postgres to specific time

or directory cp: cannot stat `/export/t/xlog/000100280030': No such file or directory On Thu, Nov 22, 2012 at 10:39 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: wd wrote: I've try to restore Postgres to a specific time but failed. The recovery.conf as bellow restore_command