Hello!
2017-11-14 12:09 GMT+01:00 Durumdara :
>
> Windows 10, PGSQL 9.4 and 9.6 (Debian with SSL, and Windows without it -
> it doesn't matter).
>
> When I (or my boss) work(s) at home, I got connection lost errors from
> PGAdmin (3/4) or from other applications too.
>
>
> server closed the conne
Hi Nicolas,
I would like to take stab at this one, as i had recently worked on a demo of
barman. But like Michael Paquier said, it is better to check the information i
provide and the situation you are facing with the maintainers of the project.
Here is what i found.
The first thing is to che
On Mon, Feb 12, 2018 at 03:23:22PM +, GALLIANO Nicolas wrote:
> I'm trying to backup a remote DB (9.6.6) using barman 2.3 but backup
> failed start.
> In barman.log i've such errors :
It would be a better idea to contact directly the maintainers of the
project here:
http://www.pgbarman.org/su
hireology_tmp=# \dx
List of installed extensions
Name | Version | Schema |
Description
--+-+--+
On 02/12/2018 04:46 PM, greigwise wrote:
I downloaded from git and compiled from source. Based on the
pglogical.control file, it appears to be 2.0.0. Is there a better way to
determine the version?
Should have added that you need run the \dx in the database you
installed pglogical into.
On 02/12/2018 04:46 PM, greigwise wrote:
I downloaded from git and compiled from source. Based on the
pglogical.control file, it appears to be 2.0.0. Is there a better way to
determine the version?
In psql do:
\dx
Thanks,
Greig
--
Sent from: http://www.postgresql-archive.org/PostgreSQL
I downloaded from git and compiled from source. Based on the
pglogical.control file, it appears to be 2.0.0. Is there a better way to
determine the version?
Thanks,
Greig
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
I downloaded it from git and compiled from source just today.
Looks like it's 2.0.0 based on the pglogical.control file that was in the
source. I'm not sure how else I'd know.
Greig
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Thanks for the info. on bcache etc., first time heard about it. But it
seems quite coarse grained for the needs of a database.
The closest thing might be this implemented by the RocksDB engine:
https://github.com/facebook/rocksdb/wiki/Persistent-Read-Cache
On Mon, Feb 12, 2018 at 9:18 AM, Steve A
On 02/12/2018 02:11 PM, greigwise wrote:
Hello. I'm trying to get pglogical setup between 2 postgres 9.6 instances.
I can get everything replicating over fine, my problem is that I can't seem
to get it to work in the mode where it does not try to copy all the data
over initially. On the source
Thiemo Kellner writes:
> I try to implement SCD2 on trigger level and try to generated needed
> code on the fly. Therefore I need to read data about the objects in the
> database. So far so good. I know of the information_schema and the
> pg_catalog. The documentation for the information_schema
Hello. I'm trying to get pglogical setup between 2 postgres 9.6 instances.
I can get everything replicating over fine, my problem is that I can't seem
to get it to work in the mode where it does not try to copy all the data
over initially. On the source side, I'm doing this:
psql -U hireology
I try to implement SCD2 on trigger level and try to generated needed
code on the fly. Therefore I need to read data about the objects in the
database. So far so good. I know of the information_schema and the
pg_catalog. The documentation for the information_schema states that it
'is defined in
On Tue, 13 Feb 2018 at 5:55 am, chiru r wrote:
> Hi,
>
> I am trying to install and configure the oracle_fdw on PostgreSQL DB
> servers.
> What we are trying is, inorder to install (make, make install) oracle_fdw
> on all DB servers,we want to compile on one server and want build a
> package/tar
Hi,
I am trying to install and configure the oracle_fdw on PostgreSQL DB
servers.
What we are trying is, inorder to install (make, make install) oracle_fdw
on all DB servers,we want to compile on one server and want build a
package/tar file to copy the library files and required SQL scripts into
a
I loved Firebird but now we have to have some cool things that Postgres has
and Firebird doesn´t.
Fiirebird has just 3 cool features that Postgres doesn´t: Computed by
columns, Position for fields and triggers and execute blocks, just that.
Replication, PITR, JSON and JSONB, XML, inherited tables
On 02/12/2018 10:02 AM, PegoraroF10 wrote:
Explaining better my problem. All reports our customer use are customizable.
So, when a customer runs a report it just runs all SQLs that are inside that
report, being SQL or Execute Blocks. But because they are completelly
customizable, one customer has
On Monday, February 12, 2018, PegoraroF10 wrote:
> Explaining better my problem. All reports our customer use are
> customizable.
> So, when a customer runs a report it just runs all SQLs that are inside
> that
> report, being SQL or Execute Blocks. But because they are completelly
> customizable
Explaining better my problem. All reports our customer use are customizable.
So, when a customer runs a report it just runs all SQLs that are inside that
report, being SQL or Execute Blocks. But because they are completelly
customizable, one customer has 80 reports with 300 Execute Blocks on them
a
PegoraroF10 wrote:
> Another approach to solve my problem would be a function that receives a
> dynamic SQL, runs it and returns a XML or JSON and on client side I convert
> that XML back to a recordset. Is that possible ?
Yet another tool that can be handy to transfer polymorphic
results
> On Feb 11, 2018, at 5:14 PM, Sand Stone wrote:
>
>
> Hi. I wonder if there is such a thing or extension in the PG world.
>
> Here is my use case. I am using PG (PG10 to be more specific) in a
> cloud VM environment. The tables are stored in RAID0 managed SSD
> backed attached storage. Depend
On 02/12/2018 08:57 AM, PegoraroF10 wrote:
I know I need to think a different approach of what execute blocks does on
Firebird.
What I was trying to was just let them the way they were wrote, because
their results are correct and with more time replace them to a new way.
That may not be necessa
I know I need to think a different approach of what execute blocks does on
Firebird.
What I was trying to was just let them the way they were wrote, because
their results are correct and with more time replace them to a new way.
But, if that way cannot be used, I´ll probably write some hundred o
On Mon, Feb 12, 2018 at 6:48 AM, PegoraroF10 wrote:
> Another approach to solve my problem would be a function that receives a
> dynamic SQL, runs it and returns a XML or JSON and on client side I convert
> that XML back to a recordset. Is that possible ?
Yes, you can pass "text" SQL into a pl/
On 02/12/2018 05:48 AM, PegoraroF10 wrote:
We can change all those execute blocks, but it would be a huge work if we
need to rewrite them all.
Today, just for a test, I replaced a Firebird execute block to a Postgres
CTE. OK, worked but I spend 40 minutes and the problem is that we have
hundreds
Hi,
I'm trying to backup a remote DB (9.6.6) using barman 2.3 but backup failed
start.
In barman.log i've such errors :
2018-02-12 16:18:23,852 [57691] barman.server ERROR: Check 'replication slot'
failed for server 'tcgepg96ddm'
2018-02-12 16:18:23,857 [57691] barman.server ERROR: Check 'recei
Luis Carril wrote:
> The transaction isolation level is serializable. This situation does not
> normally arise, because parallel query plans are not generated when the
> transaction isolation level is serializable. However, it can happen if the
> transaction isolation level is changed to serial
Hi all,
I am trying to verify if during a transaction a parallel plan ca be
generated but later only a sequential one is executed.
The documentation says the following (in
https://www.postgresql.org/docs/9.6/static/when-can-parallel-query-be-used.html):
---
Even when parallel query
Magnus Hagander writes:
> +1. And bonus points if an API can also be defined so such an extension
> parsing also becomes useful to file_fdw automatically (or at least
> optionally).
Hm, well, file_fdw already goes through COPY FROM, so it seems like it'd
almost just work. "Almost" because there'
On Sun, Feb 11, 2018 at 11:48 PM, Tom Lane wrote:
> Andres Freund writes:
> > So, I think making COPY extensible would be quite beneficial. I'm
> > however quite doubtful that we want to add core code to handle all of
> > the above. I think we should make the COPY input/output formatting
> > ext
We can change all those execute blocks, but it would be a huge work if we
need to rewrite them all.
Today, just for a test, I replaced a Firebird execute block to a Postgres
CTE. OK, worked but I spend 40 minutes and the problem is that we have
hundreds of these execute blocks and on each one we ne
Hi
From: Durumdara [mailto:durumd...@gmail.com]
Sent: Montag, 12. Februar 2018 09:32
To: Postgres General
Subject: Remove default privilege from DB
Hello!
I need to remove default privileges from a Database.
After that some of them remains.
Default access privileges
Hello!
I need to remove default privileges from a Database.
After that some of them remains.
Default access privileges
Owner| Schema | Type | Access privileges
++--+---
postgres || function | =X/postgres
postgres |
33 matches
Mail list logo
