Re: How to know if a database has changed

I think there's a more useful question, which is why do you want to do this? If it is just about conditional backups, surely the cost of backup storage is low enough, even in S3 or the like, that a duplicate backup is an afterthought from a cost perspective? Before you start jumping through hoops

Re: Unsigned RPM's ?

Hi, On Mon, 2017-12-11 at 10:19 +, Patrik Martinsson wrote: > If I'm not mistaken the latest available rpms for Red Hat 7.3 is missing > the signature, doing a simple > > $ > rpm -qpi > https://download.postgresql.org/pub/repos/yum/9.3/redhat/rhel-7.3-x86_64/post > gresql93-server-9.3.20-3P

Re: SearchSysCache() tutorial?

On 2017-12-11 12:48:27 -0800, Paul Ramsey wrote: > > > On Dec 11, 2017, at 12:40 PM, Andres Freund wrote: > > > > On 2017-12-11 11:26:51 -0800, Paul Ramsey wrote: > >> On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey > >> wrote: > >>> Is there anywhere any documentation on SearchSysCache? I find

Re: SearchSysCache() tutorial?

> On Dec 11, 2017, at 12:40 PM, Andres Freund wrote: > > On 2017-12-11 11:26:51 -0800, Paul Ramsey wrote: >> On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey >> wrote: >>> Is there anywhere any documentation on SearchSysCache? I find I end up >>> on these long spelunking expeditions through the c

Re: SearchSysCache() tutorial?

On 2017-12-11 11:26:51 -0800, Paul Ramsey wrote: > On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey > wrote: > > Is there anywhere any documentation on SearchSysCache? I find I end up > > on these long spelunking expeditions through the code base for a > > particular problem, find the answer after m

Re: SearchSysCache() tutorial?

On 2017-12-11 14:42:33 -0500, Melvin Davidson wrote: > There is no guarantee that information will be in syscache at any point in > time. It will, however, always be in the postgreSQL catalogs. That is the > whole point > of having them, and the SQL language. This doesn't make much sense. Paul's w

Re: SearchSysCache() tutorial?

There is no guarantee that information will be in syscache at any point in time. It will, however, always be in the postgreSQL catalogs. That is the whole point of having them, and the SQL language. On Mon, Dec 11, 2017 at 2:39 PM, Paul Ramsey wrote: > > On Dec 11, 2017, at 11:37 AM, Melvin Davi

Re: SearchSysCache() tutorial?

> On Dec 11, 2017, at 11:37 AM, Melvin Davidson wrote: > > > > On Mon, Dec 11, 2017 at 2:26 PM, Paul Ramsey > wrote: > On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey > wrote: > > Is there anywhere any documentation on SearchS

Re: SearchSysCache() tutorial?

On Mon, Dec 11, 2017 at 2:26 PM, Paul Ramsey wrote: > On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey > wrote: > > Is there anywhere any documentation on SearchSysCache? I find I end up > > on these long spelunking expeditions through the code base for a > > particular problem, find the answer aft

Re: SearchSysCache() tutorial?

On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey wrote: > Is there anywhere any documentation on SearchSysCache? I find I end up > on these long spelunking expeditions through the code base for a > particular problem, find the answer after many hours, then forget > everything I learned because I don'

SearchSysCache() tutorial?

Is there anywhere any documentation on SearchSysCache? I find I end up on these long spelunking expeditions through the code base for a particular problem, find the answer after many hours, then forget everything I learned because I don't exercise my knowledge frequently enough. A decent reference

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

On Sun, Dec 10, 2017 at 11:09 PM, Tsunakawa, Takayuki wrote: > It is embarrassing to ask such a thing, but is there any way to sort > character column values in EBCDIC order inside the PostgreSQL server? i.e. > is it possible to use EBCDIC collation in PostgreSQL, say, by using ICU or > someth

Re: How to know if a database has changed

Am 11.12.2017 um 18:26 schrieb Andreas Kretschmer: it's just a rough idea... ... and not perfect, because you can't capture ddl in this way. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com

Re: How to know if a database has changed

Am 11.12.2017 um 17:48 schrieb marcelo: The installation I'm planning will manage several databases, but not all of them will change every day. In order to planning/scripting the pg_dump usage, I would need to know which databases had some change activity at the end of some day. How can it be

Re: How to know if a database has changed

On 11 December 2017 at 11:48, marcelo wrote: > The installation I'm planning will manage several databases, but not all of > them will change every day. > In order to planning/scripting the pg_dump usage, I would need to know which > databases had some change activity at the end of some day. > How

Re: How to know if a database has changed

The two non elegant ways I can think of is checking the modification time on the files representing the database and a query that checks the pk of all tables. If they're ordered pk you could store the max of them and then compare, otherwise the max of an updated at column would work as well. Ji

Re: pg_dump and logging

On Mon, Dec 11, 2017 at 01:51:59PM -0300, marcelo wrote: > When pg_dump runs on a database, is it warranted that the log is fully > impacted, or at least, taken into account for the dumping? As per the second sentence in the Description section of the Fine Manual. Karsten -- GPG key ID E4071346

Re: How to know if a database has changed

Hi, a) create triggers on some tables (on update, on delete ...). let the triggers write some log, check the log or let the triggers update one central table adding database, tablenames with "table ... in database ... has been updated, modified' b) enable detailed loggin and check the system

Re: How to know if a database has changed

On Mon, Dec 11, 2017 at 01:48:44PM -0300, marcelo wrote: > The installation I'm planning will manage several databases, but not all of > them will change every day. > In order to planning/scripting the pg_dump usage, I would need to know which > databases had some change activity at the end of som

pg_dump and logging

When pg_dump runs on a database, is it warranted that the log is fully impacted, or at least, taken into account for the dumping? TIA

How to know if a database has changed

The installation I'm planning will manage several databases, but not all of them will change every day. In order to planning/scripting the pg_dump usage, I would need to know which databases had some change activity at the end of some day. How can it be done? TIA

Re: Unsigned RPM's ?

I'm going ahead and answering my self. Apparently this issue was already posted in the postgresql-yum-list. https://www.postgresql.org/message-id/flat/CAAQZgJyWQdfCpNXFaT6vtWGuztWCMQf_kakjxjwTkUFJidCtqg%40mail.gmail.com#caaqzgjywqdfcpnxfat6vtwguztwcmqf_kakjxjwtkufjidc...@mail.gmail.com // Patrik

Re: PostgreSQL is so hip again

On 11/12/2017 16:43, Ray Stell wrote: InfoWorld on postgresql: https://www.infoworld.com/article/3240064/sql/why-old-school-postgresql-is-so-hip-again.html?idg_eid=d088f0ac35204f7a4055d4fd64053ac3&email_SHA1_lc=d3136cf9e64ce7067d0fe82239bbd76e165586bc&cid=ifw_nlt_infoworld_developer_2017-12-08&u

Re: Removing INNER JOINs

Jim Finnerty writes: > Great example, David. The planner can detect whether a SELECT statement > contains a volatile function, and can disable the proposed redundant > inner-join optimization in that case. > If necessary, the planner could also check that the FK constraint is not > DEFERRED, b

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

"Tsunakawa, Takayuki" writes: > It is embarrassing to ask such a thing, but is there any way to sort > character column values in EBCDIC order inside the PostgreSQL server? i.e. > is it possible to use EBCDIC collation in PostgreSQL, say, by using ICU or > something? We need to run on a certa

PostgreSQL is so hip again

InfoWorld on postgresql: https://www.infoworld.com/article/3240064/sql/why-old-school-postgresql-is-so-hip-again.html?idg_eid=d088f0ac35204f7a4055d4fd64053ac3&email_SHA1_lc=d3136cf9e64ce7067d0fe82239bbd76e165586bc&cid=ifw_nlt_infoworld_developer_2017-12-08&utm_source=Sailthru&utm_medium=email&utm

Re: Windows XP to Win 10 migration issue

On Sat, 9 Dec 2017 10:11:42 -0600 Dale Seaburg wrote: >   No Go!  Would not start.  Any error message in your logs? I would certainly second Scott's suggestion to check the processors. I've had to do what you describe once, and it took me four machines before I got one that would start postgr

Unsigned RPM's ?

Hello, If I'm not mistaken the latest available rpms for Red Hat 7.3 is missing the signature, doing a simple $ > rpm -qpi https://download.postgresql.org/pub/repos/yum/9.3/redhat/rhel-7.3-x86_64/postgresql93-server-9.3.20-3PGDG.rhel7.x86_64.rpm " Gives me, $ > Name: postgresql93-server

Re: Display table entries using partial column entry

On 11-12-17 00:39, Gmail wrote: > > > On Dec 10, 2017, at 4:10 PM, Melvin Davidson > wrote: > >> >> >> On Sun, Dec 10, 2017 at 4:50 PM, Sherman Willden >> mailto:operasopra...@gmail.com>> wrote: >> ... >> Thank you; >> >> Sherman >> >> >> Sherman, >> In the

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

Tsunakawa, Takayuki wrote: > It is embarrassing to ask such a thing, but is there any way to sort > character column values in EBCDIC order inside the PostgreSQL server? > i.e. is it possible to use EBCDIC collation in PostgreSQL, say, by using ICU > or something? We need to run on a certain mai