Hello!
Is there a way to decrypt data encrypted with the pgcrypto "encrypt"
function, outside the database? Assuming that I know the key etc...
Thanks!
-- Stephen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
On Wed, Sep 6, 2017 at 9:43 AM, Robert Inder
wrote:
...
> And I've read that the answer to this is to set
> max_standby_streaming_delay in postgresql94.conf.
> So I've set it to "600s" -- ten minutes.
>
> I thought this would mean that when there was a conflict with an update
> from the live ser
hi,
I am trying to implement logical replication stream API of postgresql.
I am facing unusual connection breakdown problem. Here is the simple code
that I am
using to read WAL file:
String url = "jdbc:postgresql://pcnode2:5432/benchmarksql";
Properties props = new Properties();
On Wed, Sep 06, 2017 at 08:22:14AM -0700, Steve Atkins wrote:
> > On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
> >
> > Hi, is there any way (3rd party software) to replicate particular
> > schema/table not the whole database with streaming replication built-in
> > mechanism ?
>
> I don't be
A server running PostgreSQL 9.4 on Centos 6.8, with a live server and a hot
standby, is supporting about 20 customer organisations, each with their own
linux user and its own installation/copy of the system, talking to its own
database.
The system has a backup script which is a wrapper round pg_du
Debian Stretch AMD-64, Postgresql 9.6.3
Streaming data from live server and we see these messages on the hot
standby server.
2017-09-06 14:42:09 BST 11548 WARNING: page 30558 of relation
base/2497261/2504373 is uninitialized
2017-09-06 14:42:09 BST 11548 CONTEXT: xlog redo at 44/5E0B7
Streaming data from live server and we see these messages on the hot
standby server.
2017-09-06 14:42:09 BST 11548 WARNING: page 30558 of relation
base/2497261/2504373 is uninitialized
2017-09-06 14:42:09 BST 11548 CONTEXT: xlog redo at 44/5E0B7CA8 for
Heap2/VISIBLE: cutoff xid 2918231
> On Sep 6, 2017, at 8:48 AM, Marcin Giedz wrote:
>
> Does pglogical support views replication as I can't find it in any
> restrictions ?
There's no need to replicate the contents of a view, as it doesn't contain any
data.
pglogical can replicate the initial schema, including any views, but
Does pglogical support views replication as I can't find it in any restrictions
?
Thx
Marcin
Od: "Steve Atkins"
Do: pgsql-general@postgresql.org
Wysłane: środa, 6 wrzesień 2017 17:22:14
Temat: Re: [GENERAL] Schema/table replication
> On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
>
> On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
>
> Hi, is there any way (3rd party software) to replicate particular
> schema/table not the whole database with streaming replication built-in
> mechanism ?
I don't believe so. You can do that with logical replication in v10 -
https://www.po
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 06 September 2017 15:49
To: Rob Northcott
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dealing with number formats when server and client are
different locales
Rob Northcott writes:
> The problem we've got
Rob Northcott writes:
> The problem we've got is that our app (running on PCs) generates commands to
> send to the SQL server, such as
> UPDATE customers SET cus_balance = 10.4 WHERE cus_key = 'A001'
> This has been working historically because the clients were always UK-based.
> Now some users
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 06 September 2017 13:36
To: Rob Northcott
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dealing with number formats when server and client are
different locales
Rob Northcott writes:
> Our application was wri
Hi, is there any way (3rd party software) to replicate particular schema/table
not the whole database with streaming replication built-in mechanism ?
Thx
Marcin
Rob Northcott writes:
> Our application was written assuming that the SQL server local settings for
> number formats would be the same as the client machine running the
> application.
> Now there is a need for some clients to run using UK format (full stop for
> decimal separator) and some to b
Sorry, replied only to direct sender, duplicating to both sender and
mailing list
*---*
*MSG1:*
Thanks you, that is what I was looking for!
I was testing sample module and found it's behavior odd:
1. functions have few permissions, they even were not able to create file
in "/tmp" directory. At lea
On Wed, Sep 6, 2017 at 1:16 AM, Vijay Chaudhery wrote:
> Ok is it possible to release the lock? or it is just a warning messages
> only?
> thanks
>
The message starts with "ERROR" so it is an error, not a warning. The
command failed. The only way to release the lock is to have the other
connecti
I have inserted a row that i don't touch, runned ANALYZE and tried again
but with the same result.
I'm using postgres 9.6.3 and EXPLAIN ANALYZE shows this:
Index Scan using users_username_idx on users (cost=0.13..8.14 rows=1
width=4) (actual time=0.020..0.020 rows=0 loops=1)
Index Cond: (nam
I thinking that i have found the culprit. SSI locks leaf pages on the btree
index so if the different values are covered by the same page i will get a
serialization failure
Is this correct?
On mer 30 ago 2017, 08:45 Luca Looz wrote:
> I have inserted a row that i don't touch, runned ANALYZE and
I had the following subsequent correspondence with EnterpriseDB.
From: EnterpriseDB Customer Support
To:
Sent: 25 Aug 2017, 10:19 AM
Your concern for missing 'plpython2.dll' file from the PostgreSQL 9.6
installer(by EnterpriseDB) was redirected to the EnterpriseDB support portal
by one of our
Our application was written assuming that the SQL server local settings for
number formats would be the same as the client machine running the application.
Now there is a need for some clients to run using UK format (full stop for
decimal separator) and some to be European format (comma for decim
On 6 September 2017 at 08:47, milist ujang wrote:
> Hi Craig
>
> On Wed, Sep 6, 2017 at 7:21 AM, Craig Ringer
> wrote:
>>
>>
>> BDR can, see bdr.skip_changes_upto .
>>
>> Unluckily my bdr is 0.9.3
>
>
>> But PostgreSQL's logical decoding requires a contiguous WAL stream to
>> maintain a valid ca
Hi,
I'm getting inconsistent Postgres errors, when we upgrade our product that
bundles PostgreSQL 9.3.4.
We have 13 databases and we get errors at different places of the database
setup.
Here are the failures:
1.
$POSTGRES/bin/psql -c " CREATE SEQUENCE serial1 START 1 CYCLE ;" -d $ARCHDB
exitIfC
23 matches
Mail list logo
