Hi,
I am running the postgres docker image with that version:
2023-09-20 10:36:32.478 CEST [1] LOG: starting PostgreSQL 13.12 (Debian
13.12-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14)
12.2.0, 64-bit
2023-09-20 10:36:32.564 CEST [1] LOG: listening on IPv4 address "0
Am Mittwoch, dem 20.09.2023 um 13:11 +0200 schrieb Laurenz Albe:
> Is that an NFS mount? What are the mount options?
>
> Yours,
> Laurenz Albe
No mount at all.
Just the docker container filesystem using the overlay2 storage driver,
there is nothing externally mounted in that container, the data
On Wed, 2023-09-20 at 10:49 +0200, Torsten Krah wrote:
> I am running the postgres docker image with that version:
>
> 2023-09-20 10:36:32.478 CEST [1] LOG: starting PostgreSQL 13.12 (Debian
> 13.12-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14)
> 12.2.0, 64-bit
> 2023-
Erik,
Thanks for responding. All of the DDL is just the setup for the test
case. I ran those steps in both databases to setup the exact same
environment. The COMMIT is not needed for the test out of habit I put it
in my setup. The main issue is in 14.3 I can run this select as user
sten_schema
On 9/19/23 10:09, Anthony Apollis wrote:
I have a table that needs to give me all data up until yesterday. This
All data since, beginning of month, beginning of year, beginning of time?
will be part of an SSIS package that runs monthly, a day before the last
day. code is:
You need to provide
On 2023-Sep-19, Anthony Apollis wrote:
> I have inherited this code, problem is it is over code, i believe. The
> package is gonna run once a month and this code run is a loop. How can this
> loop be running and checking data up until last day, if it only run once a
> month?
I didn't stop to unde
On 2023-09-20 09:15 -0400, Michael Corey wrote:
> Thanks for responding. All of the DDL is just the setup for the test
> case. I ran those steps in both databases to setup the exact same
> environment.
And both databases start empty or at least in the exact same state?
> The COMMIT is not neede
PG 14 Server
psql (14.2, server 14.3)
You are now connected to database "db14" as user "postgres".
db14=> \dn+ ref_schema|sten_schema
List of schemas
Name |Owner|Access privileges| Description
-+-+---
On 9/20/23 10:59 AM, Harry Green wrote:
Thank you Laurenz for your answer,
I have done a complete pg_dump and complete restore, and tried all
forms of complete pg_dumps and restores (i.e. the different formats).
There is no partial or tables only or data only dumping or restoring.
Further, yo
Thank you Laurenz for your answer,I have done a complete pg_dump and complete
restore, and tried all forms of complete pg_dumps and restores (i.e. the
different formats). There is no partial or tables only or data only dumping or
restoring. Further, you refer to a 'check constraint' but this is
Thanks for your answer,I have done a complete pg_dump and complete restore,
and tried all forms of complete pg_dumps and restores (i.e. the different
formats). There is no partial or tables only or data only dumping or restoring.
Further, you refer to a 'check constraint' but this is just a fu
On 2023-09-20 13:17 -0400, Michael Corey wrote:
> PG 14 Server
> psql (14.2, server 14.3)
> You are now connected to database "db14" as user "postgres".
> db14=> \dn+ ref_schema|sten_schema
> List of schemas
> Name |Owner|Access privileges
Erik,
Just to be clear in your last response are you saying on your 14.3 you are
getting the
ERROR: permission denied for table ref_media_code ?
If this is true then it seems to be something in our setup. This database
may have been upgraded from 13.x to 14. The sten_schema has INHERIT when I
Hello All,
I see multiple docs on the internet, stating the difference between Mysql
and postgres. But I want to understand the real views of the experienced
folks here.
While we are on AWS and planning to opt for one of the relational databases
out of mysql and postgres for our application(It is
Hello,
I have been struggling with trying to use a current version of libpq to link
against on macOS in Xcode. It seems that nothing works, nobody on the web
eventually succeeded either as far as I found so far. I try to write a small
sample client. I started with the public source download to
On Wed, 2023-09-20 at 17:59 +, Harry Green wrote:
> I have done a complete pg_dump and complete restore, and tried all forms of
> complete
> pg_dumps and restores (i.e. the different formats). There is no partial or
> tables only
> or data only dumping or restoring. Further, you refer to a 'c
Michael Corey ezt írta (időpont: 2023.
szept. 20., Sze, 20:48):
> ... All of the DDL is just the setup for the test case. I ran those steps
> in both databases to setup the exact same environment. The COMMIT is not
> needed for the test out of habit I put it in my setup. The main issue is
> in
On Thu, 2023-09-21 at 01:17 +0530, veem v wrote:
> I see multiple docs on the internet, stating the difference between Mysql and
> postgres.
> But I want to understand the real views of the experienced folks here.
>
> While we are on AWS and planning to opt for one of the relational databases
>
Thank you.
Yes feature wise postgres seems rich as I read multiple blogs. And right
now, I can't think of any other reason for opting mysql though as opposed
to postgres.
However, One of the things regarding the transaction management, which I
see in most postgres blogs is 'mvcc'(multiversion con
On Wed, Sep 20, 2023 at 2:06 PM Harry Green wrote:
> I attach the text of the entire create function instruction, and also of
> the create table instruction.
>
>
The restore is not going to execute functions on its own and you've only
shown two create statements. Somewhere else in your dump file
> On Sep 20, 2023, at 14:11, veem v wrote:
>
> Does AWS aurora postgres depend on the same vacuuming technology for
> maintaining the transactions?
Yes. Aurora has replaced the PostgreSQL storage engine, but the MVCC part is
largely the same. The issues with vacuuming are largely oversta
On Wed, Sep 20, 2023 at 2:20 PM Erik Wienhold wrote:
> Has your 14.3 some left-over state from previous test runs? I assume
> the server is not re-created for each test run. I was wondering if the
> roles may still exist and with additional memberships. But then again
> the script just uses CR
David,
How can I check the default privileges?
On Wed, Sep 20, 2023 at 5:24 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, Sep 20, 2023 at 2:20 PM Erik Wienhold wrote:
>
>> Has your 14.3 some left-over state from previous test runs? I assume
>> the server is not re-created
Erik,
To make matters even more strange. I checked the permissions of
rds_superuser in 15 and 14
For 14
GRANT pg_monitor, pg_signal_backend, rds_password, rds_replication TO
rds_superuser WITH ADMIN OPTION;
For 15
GRANT pg_checkpoint, pg_monitor, *pg_read_all_data*, pg_signal_backend,
*pg_write
On Wed, Sep 20, 2023 at 2:48 PM Michael Corey
wrote:
> How can I check the default privileges?
>
\ddp
https://www.postgresql.org/docs/current/catalog-pg-default-acl.html
David J.
On 2023-09-20 14:24 -0700, David G. Johnston wrote:
> On Wed, Sep 20, 2023 at 2:20 PM Erik Wienhold wrote:
>
> > Has your 14.3 some left-over state from previous test runs? I assume
> > the server is not re-created for each test run. I was wondering if the
> > roles may still exist and with add
On 2023-09-20 15:19 -0400, Michael Corey wrote:
> Just to be clear in your last response are you saying on your 14.3 you are
> getting the
> ERROR: permission denied for table ref_media_code ?
Yes:
db14=> select version();
On 2023-09-20 17:53 -0400, Michael Corey wrote:
> To make matters even more strange. I checked the permissions of
> rds_superuser in 15 and 14
>
> For 14
> GRANT pg_monitor, pg_signal_backend, rds_password, rds_replication TO
> rds_superuser WITH ADMIN OPTION;
>
> For 15
> GRANT pg_checkpoint, p
On Thu, 2023-09-21 at 02:41 +0530, veem v wrote:
> However, One of the things regarding the transaction management, which I see
> in
> most postgres blogs is 'mvcc'(multiversion concurrency control) being an issue
> at times in a heavy concurrent system, in postgres as its maintaining exact
> copi
29 matches
Mail list logo