Hi,
We're using asynchronous streaming replication together with WAL archiving and
recovery (we've set these parameters: archive_command, restore_command,
recovery_target_timeline=latest).
To manage backup and recovery, we're using pg_probackup.
We have a 3-node cluster managed by Patroni on Raft
Requirement is to use only ca.crt and connect to postgres
Server.crt, Server.key and ca.crt are configured at the postgres server for
tls connection.
Connection successful while using
psql ‘host=172.29.21.222 dbname=test user=postgres sslmode=verify-ca
sslcert=/tmp/server.crt sslkey=/tmp/server.k
Hello,
This is with 14.1 on Linux. I have created a new database with
$ createdb -U sisis -T template0 SRP-27097
I can connect to it, created tables and fill them with SQL:
$ psql -Usisis -dSRP-27097
psql (14.1)
Geben Sie »help« für Hilfe ein.
SRP-27097=# select count(*) from sisisinst;
cou
Hi,
On Mon, Aug 01, 2022 at 11:22:33AM +0200, Matthias Apitz wrote:
>
> This is with 14.1 on Linux. I have created a new database with
>
> $ createdb -U sisis -T template0 SRP-27097
>
> I can connect to it, created tables and fill them with SQL:
>
> but I can not drop the database:
>
> $ psql -Usi
Am Mon, Aug 01, 2022 at 11:22:33AM +0200 schrieb Matthias Apitz:
> testdb=# DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
> ERROR: syntax error at or near "-"
> ZEILE 1: DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
>
> Why is this?
Please try: DROP DATABASE IF EXISTS "SRP-27097" WITH FORCE;
On 2022-08-01 04:06, Adrian Klaver wrote:
2022-08-01T00:20:18.530Z Connection-1 finer] Created socket
[2022-08-01T00:20:18.532Z Connection-1 fine] Opening connection to
port 5432 on host localhost
2022-08-01 01:20:18.534308+0100 TestPostgres[10654:120173]
dnssd_clientstub ConnectToServer: conne
Apologies for the rather naive question.
I have a psql migration script to call a looping procedure which commits
batches of data along the following lines:
set search_path = a, b c;
\set AUTOCOMMIT on
-- call procedure with nested transactions
CALL c.pr_my_procedure(debug=>true);
Hi,
Le lun. 1 août 2022 à 15:10, Rory Campbell-Lange
a écrit :
> Apologies for the rather naive question.
>
> I have a psql migration script to call a looping procedure which commits
> batches of data along the following lines:
>
> set search_path = a, b c;
> \set AUTOCOMMIT on
> --
Hello,
Why can a user access a table from a forbidden schema if the table is
explicitly specified in the definition of a view in an allowed schema? And
not if the table is accessed by a function used in the view.
Example:
```
DROP SCHEMA IF EXISTS forbidden_schema CASCADE;
DROP SCHEMA IF EXISTS a
=?UTF-8?Q?Marcin_Barczy=C5=84ski?= writes:
> Why can a user access a table from a forbidden schema if the table is
> explicitly specified in the definition of a view in an allowed schema? And
> not if the table is accessed by a function used in the view.
(1) Whether a view can access a table is d
10 matches
Mail list logo
