Re: Does PostgreSQL check database integrity at startup?

This whole discussion left out the critical point of *how on earth did that file end up having zero bytes?* There is the possibility that this is due to a bug in PostgreSQL. But over the 20+ years I've been using and hacking it, that has never happened. OP never told us what type of OS, hardwar

Re: Does PostgreSQL check database integrity at startup?

Melvin, * Melvin Davidson (melvin6...@gmail.com) wrote: > >the query is outright wrong. > Really? I submit a query to help and all you can do is criticize? I explained exactly what was wrong with it, and how to write a proper query to answer this question, with the thought that you'd appreciate t

Re: Does PostgreSQL check database integrity at startup?

> On Dec 29, 2017, at 6:14 PM, Melvin Davidson wrote: > > Edson's original request was for a query that shows the FILENAMEs for the > table. Which the query you provide does not do. > As for "qood" query, that is entirely an opinion. But a well informed one. Your query may work well enough

Re: Does PostgreSQL check database integrity at startup?

>the query is outright wrong. Really? I submit a query to help and all you can do is criticize? Yes it is legal to create a table that starts with pg_, but any PostgreSQL developer should know that is not a good idea. If you don't like the query, write a better one yourself, but kindly do not try

Re: Does PostgreSQL check database integrity at startup?

Melvin, * Melvin Davidson (melvin6...@gmail.com) wrote: > On Fri, Dec 29, 2017 at 9:07 PM, Stephen Frost wrote: > > * Melvin Davidson (melvin6...@gmail.com) wrote: > > > >There should be a "catalog" that point where tables are stored in > > physical > > > files... > > > > > > Here is the query th

Re: Does PostgreSQL check database integrity at startup?

On Fri, Dec 29, 2017 at 9:07 PM, Stephen Frost wrote: > Greetings, > > * Melvin Davidson (melvin6...@gmail.com) wrote: > > >There should be a "catalog" that point where tables are stored in > physical > > files... > > > > Here is the query that gives you that information. > > > > SELECT c.oid, >

Re: Does PostgreSQL check database integrity at startup?

Greetings, * Melvin Davidson (melvin6...@gmail.com) wrote: > >There should be a "catalog" that point where tables are stored in physical > files... > > Here is the query that gives you that information. > > SELECT c.oid, >n.nspname as schema, >c.relname as table,

Re: Does PostgreSQL check database integrity at startup?

>There should be a "catalog" that point where tables are stored in physical files... Here is the query that gives you that information. SELECT c.oid, n.nspname as schema, c.relname as table, (SELECT oid FROM pg_database WHERE datname = current_database(

Re: Does PostgreSQL check database integrity at startup?

Greetings, * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > There should be a "catalog" that point where tables are stored in physical > files (I think, at least, because at some point PostgreSQL need to know from > where to read the data). Yes, it's pg_class. Specifically, the

Re: Does PostgreSQL check database integrity at startup?

Jan, all, * Jan Wieck (j...@wi3ck.info) wrote: > On Thu, Dec 28, 2017 at 1:26 PM, Stephen Frost wrote: > > * Brent Wood (pcr...@yahoo.com) wrote: > > > A tool to calculate a checksum of sorts based on the table (file) > > content would provide a better surety of duplication than simply checking >

Re: Does PostgreSQL check database integrity at startup?

Em 29/12/2017 22:14, Jan Wieck escreveu: On Thu, Dec 28, 2017 at 1:26 PM, Stephen Frost > wrote: Greetings Brent, * Brent Wood (pcr...@yahoo.com ) wrote: > A tool to calculate a checksum of sorts based on the table (file) co

Re: Does PostgreSQL check database integrity at startup?

On Thu, Dec 28, 2017 at 1:26 PM, Stephen Frost wrote: > Greetings Brent, > > * Brent Wood (pcr...@yahoo.com) wrote: > > A tool to calculate a checksum of sorts based on the table (file) > content would provide a better surety of duplication than simply checking > file size - like differently vacu

Re: Oacle to Postgres migration

you can see this http://ora2pg.darold.net/ El 25-12-2017 9:29 p. m., "Azimuddin Mohammed" escribió: > Hello, > Can anyone suggest me > > -- > > Regards, > Azim > > > > >

Re: PgBackRest question?

Thank you very much David and Stephen for your quick reply. On Fri, Dec 29, 2017 at 1:55 PM, David Steele wrote: > On 12/29/17 1:53 PM, Stephen Frost wrote: > > Greetings, > > > > * David Steele (da...@pgmasters.net) wrote: > >> On 12/28/17 6:15 PM, chiru r wrote: > >>> I am unable to copy the c

Re: PgBackRest question?

On 12/29/17 1:53 PM, Stephen Frost wrote: > Greetings, > > * David Steele (da...@pgmasters.net) wrote: >> On 12/28/17 6:15 PM, chiru r wrote: >>> I am unable to copy the complete backup.manifest file due to security >>> reasons . please find the below contents. >>> >>> [backup:target] >>> pg_data=

Re: PgBackRest question?

Greetings, * David Steele (da...@pgmasters.net) wrote: > On 12/28/17 6:15 PM, chiru r wrote: > > I am unable to copy the complete backup.manifest file due to security > > reasons . please find the below contents. > > > > [backup:target] > > pg_data={"path":"/u02/pgdata01/9.5/data","type":"path"}

Re: PgBackRest question?

On 12/28/17 6:15 PM, chiru r wrote: > > I am unable to copy the complete backup.manifest file due to security > reasons . please find the below contents. > > [backup:target] > pg_data={"path":"/u02/pgdata01/9.5/data","type":"path"} > pg_tblspc/721349={"path":"/u02/pgdata02/report1","tablespace-id

Re: Mimic parse bind execute in psql?

Jeremy Finzel writes: > If I want to mimic a log statement that is from an application that uses > PARSE/BIND/EXECUTE, is there any way to mimic this behavior in psql, for > example to troubleshoot execution plans, other than writing a named > prepared statement, or manually subbing the parameters

Re: PgBackRest question?

Can you please help on below pgbackrest restoration issue. On Thu, Dec 28, 2017 at 6:15 PM, chiru r wrote: > > I am unable to copy the complete backup.manifest file due to security > reasons . please find the below contents. > > [backup:db] > db-catalog-version=201510051 > db-control-version=942

Mimic parse bind execute in psql?

If I want to mimic a log statement that is from an application that uses PARSE/BIND/EXECUTE, is there any way to mimic this behavior in psql, for example to troubleshoot execution plans, other than writing a named prepared statement, or manually subbing the parameters? It would be nice to take the

Re: postgresql9.5 partition table

Hi Herrera Thanks for your reply. I will try it in postgresql10. Regards, Mark 发自网易邮箱手机版 在2017年12月29日 21:46，Alvaro Herrera 写道： mark wrote: > I defined a table using 1000 partition tables. > When I deleted or updated this table. It used a lot of memory and > postmaster process is killed by OS. Wh

Re: postgresql9.5 partition table

mark wrote: > I defined a table using 1000 partition tables. > When I deleted or updated this table. It used a lot of memory and > postmaster process is killed by OS. When I defined the same table > using 100 partition tables. It can normally be updated and deleted. > what is reason of this? Postg

postgresql9.5 partition table

I defined a table using 1000 partition tables. When I deleted or updated this table. It used a lot of memory and postmaster process is killed by OS. When I defined the same table using 100 partition tables. It can normally be updated and deleted. what is reason of this?

Re: pool connection

On Fri, Dec 29, 2017 at 11:47:01AM +0100, hmidi slim wrote: > I'm trying to understand the utility of pool connection, I found that it's > useful to enhance the performance of a database. However I want to know if > it is a good option to put a large number in max_connection option to > handle a la

pool connection

HI, I'm trying to understand the utility of pool connection, I found that it's useful to enhance the performance of a database. However I want to know if it is a good option to put a large number in max_connection option to handle a large number of connection in an app?