Re: [table partitioning] How many partitions are possibel?

Hi, Am 2017-12-26 hackte Michael Paquier in die Tasten: > On Tue, Dec 26, 2017 at 11:04:55AM +0100, Michelle Konzack wrote: >> I like to make the partitions smaller, but the documentation say, you >> should not dare to make s

Re: Deadlock between concurrent index builds on different tables

On Tue, Dec 26, 2017 at 11:11 AM, Alvaro Herrera wrote: > Jeremy Finzel wrote: > > On Tue, Dec 26, 2017 at 10:28 AM, Alvaro Herrera < > alvhe...@alvh.no-ip.org> > > wrote: > > > > > Jeremy Finzel wrote: > > > > > > > > > >> Each index build needs to wait for all other transactions > > > > >> (Inc

postgresql-10 for ubuntu-17.10 (artful)?

Is there a repository for Postgresql-10 available at http://apt.postgresql.org/pub/repos/apt for Ubuntu-17.10 (artful)? When I look at the dist/ subdirectory there, there seem to be repos for all the other Ubuntu releases including an upcoming one (bionic) but not artful. Am I looking in the

Re: [table partitioning] How many partitions are possibel?

On Tue, Dec 26, 2017 at 11:04:55AM +0100, Michelle Konzack wrote: > I like to make the partitions smaller, but the documentation say, you > should not dare to make several 1000 partitions.. Even more than a hundred may be already risky in my opinion here. The issue with a large number of partition

Re: Deadlock between concurrent index builds on different tables

On Wed, Dec 27, 2017 at 12:27:05AM +0100, Alban Hertroys wrote: > >> On 26 Dec 2017, at 18:11, Alvaro Herrera wrote: > > … > > > 3. configure and make > > ./configure > > make > > make install > > … > > > For the options in step 3 you could use whatever your current server > > has; use

Re: Deadlock between concurrent index builds on different tables

> On 26 Dec 2017, at 18:11, Alvaro Herrera wrote: … > 3. configure and make > ./configure > make > make install … > For the options in step 3 you could use whatever your current server > has; use "pg_config --configure" to find these out. You're gonna need > same flags if you want to

Re: Does PostgreSQL check database integrity at startup?

El 26/12/17 a las 14:46, Edson Carlos Ericksson Richter escribió: > > Usually, or by "pg_basebackup" or by "rsync" as described in PostgreSQL > Wiki. > Right now, I'm doing via pg_basebackup. > Nothing extraordinary. > > When using rsync: > > rsync -e "ssh -2 -C -p slave_ssh_port" --progress --p

Re: Does PostgreSQL check database integrity at startup?

Hello, On Tue, 2017-12-26 at 18:58 -0300, Alvaro Herrera wrote:Hello, > David Steele wrote: > > > pgBackRest will validate all page checksums (including indexes, > > etc.) in the > > cluster during backup. Full backups check everything, > > incr/differential > > backups check only the files tha

Re: Does PostgreSQL check database integrity at startup?

David Steele wrote: > pgBackRest will validate all page checksums (including indexes, etc.) in the > cluster during backup. Full backups check everything, incr/differential > backups check only the files that have changed. If a table or index file is of zero length when backed up, as in the desc

Re: Does PostgreSQL check database integrity at startup?

On 12/26/17 10:57 AM, Pavel Stehule wrote: 2017-12-26 16:50 GMT+01:00 Edson Carlos Ericksson Richter I'm rebuilding the standby server for two days already, with 23% of completion status... If lost the database and backups because of that failure, it would be a giant disaster.

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 15:13, Alvaro Herrera escreveu: Edson Carlos Ericksson Richter wrote: I'm rebuilding the standby server for two days already, with 23% of completion status... So how do you build your standbys, exactly? Maybe there's a bug in your procedure, rather than a bug in the software.

Re: Does PostgreSQL check database integrity at startup?

Edson Carlos Ericksson Richter wrote: > I'm rebuilding the standby server for two days already, with 23% of > completion status... So how do you build your standbys, exactly? Maybe there's a bug in your procedure, rather than a bug in the software. -- Álvaro Herrerahttps://www.

Re: Deadlock between concurrent index builds on different tables

Jeremy Finzel wrote: > On Tue, Dec 26, 2017 at 10:28 AM, Alvaro Herrera > wrote: > > > Jeremy Finzel wrote: > > > > > > > >> Each index build needs to wait for all other transactions > > > >> (Including the ones used by the other index build) to finish. > > > >> So I don't think a deadlock here i

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 13:57, Pavel Stehule escreveu: 2017-12-26 16:50 GMT+01:00 Edson Carlos Ericksson Richter mailto:rich...@simkorp.com.br>>: Em 26/12/2017 13:40, Pavel Stehule escreveu: 2017-12-26 16:37 GMT+01:00 Edson Carlos Ericksson Richter mailto:rich...@simkorp.com.br>>:

Re: Deadlock between concurrent index builds on different tables

On Tue, Dec 26, 2017 at 10:28 AM, Alvaro Herrera wrote: > Jeremy Finzel wrote: > > > > > > > > >> Each index build needs to wait for all other transactions > > >> (Including the ones used by the other index build) to finish. > > >> So I don't think a deadlock here is unexpected. > > > Does that m

Re: Deadlock between concurrent index builds on different tables

Jeremy Finzel wrote: > > > > > >> Each index build needs to wait for all other transactions > >> (Including the ones used by the other index build) to finish. > >> So I don't think a deadlock here is unexpected. > Does that mean I should never build more than one concurrent index at > a time withi

Re: Does PostgreSQL check database integrity at startup?

2017-12-26 16:50 GMT+01:00 Edson Carlos Ericksson Richter < rich...@simkorp.com.br>: > Em 26/12/2017 13:40, Pavel Stehule escreveu: > > > > 2017-12-26 16:37 GMT+01:00 Edson Carlos Ericksson Richter < > rich...@simkorp.com.br>: > >> Em 26/12/2017 12:25, Pavel Stehule escreveu: >> >> >> >> 2017-12-2

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 13:40, Pavel Stehule escreveu: 2017-12-26 16:37 GMT+01:00 Edson Carlos Ericksson Richter mailto:rich...@simkorp.com.br>>: Em 26/12/2017 12:25, Pavel Stehule escreveu: 2017-12-26 14:44 GMT+01:00 Martin Marques mailto:martin.marq...@2ndquadrant.com>>: El 2

Re: Does PostgreSQL check database integrity at startup?

2017-12-26 16:37 GMT+01:00 Edson Carlos Ericksson Richter < rich...@simkorp.com.br>: > Em 26/12/2017 12:25, Pavel Stehule escreveu: > > > > 2017-12-26 14:44 GMT+01:00 Martin Marques > : > >> El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: >> > Recently I had a problem with a bas

Re: Does PostgreSQL check database integrity at startup?

Look into amcheck: https://github.com/petergeoghegan/amcheck -- Peter Geoghegan (Sent from my phone)

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 12:25, Pavel Stehule escreveu: 2017-12-26 14:44 GMT+01:00 Martin Marques mailto:martin.marq...@2ndquadrant.com>>: El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > Recently I had a problem with a base file with size 0 in a standby server. >

Re: Does PostgreSQL check database integrity at startup?

2017-12-26 14:44 GMT+01:00 Martin Marques : > El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > > Recently I had a problem with a base file with size 0 in a standby > server. > > > > This raised one question: does PostgreSQL (9.6.6) check base integrity > > at startup? > > > > At

Re: Does PostgreSQL check database integrity at startup?

El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > Recently I had a problem with a base file with size 0 in a standby server. > > This raised one question: does PostgreSQL (9.6.6) check base integrity > at startup? > > At least if there are 0 byte size files in base dir? Or CRC?

Re: Oracle to postgres migration

On Tue, Dec 26, 2017, at 02:30, Azimuddin Mohammed wrote: > Hello, > Can anyone guide me through the steps for migration from oracle to > postgres with config changes required, keeping in mind that neither I > am a oracle DBA not postgres admin> > -- > > Regards, > Azim > > > Virus-free. www.

Does PostgreSQL check database integrity at startup?

Recently I had a problem with a base file with size 0 in a standby server. This raised one question: does PostgreSQL (9.6.6) check base integrity at startup? At least if there are 0 byte size files in base dir? Or CRC? Something? Regards, -- *Edson Carlos Ericksson Richter* /SimKorp Ltda/

Re: Oracle to postgres migration

On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote: > I'd start with this first : https://ora2pg.darold.net > >> On 26 Dec 2017, at 02:30, Azimuddin Mohammed >> wrote:>> >> Hello, >> Can anyone guide me through the steps for migration from oracle to >> postgres with config changes required

[table partitioning] How many partitions are possibel?

Hello *, Long time ago I used VIEWs on my history database and when PostgreSQL introduced table partitioning I was switching to it. Currently I use Debian GNU/Linux 7.11 with PostgreSQL 9.1 (table space and table partitioning) using an Adaptec 16-Channel Raid-1 Controller with 16x 6 TByte SAS Ult

Re: Oracle to postgres migration

I'd start with this first : https://ora2pg.darold.net > On 26 Dec 2017, at 02:30, Azimuddin Mohammed wrote: > > Hello, > Can anyone guide me through the steps for migration from oracle to postgres > with config changes required, keeping in mind that neither I am a