Skip to main content

Questions tagged [postgres-14]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 views

Crunchydata - PGO - Postgres(v 14.x) restore not working as expected

We have set up PostgreSQL, including its backup and recovery processes based on crunchy data Postgres Operator, as per the documentation. The backups are occurring as expected. However, when we ...
Neeraj Bhatewara's user avatar
0 votes
1 answer
32 views

how to move a postgres tablespace on windows?

Now do I move a tablespace on a windows installation of postgres? This thread shows how to do it on unix, not windows. The tablespace was originally created with this command... CREATE TABLESPACE ...
ConanTheGerbil's user avatar
0 votes
1 answer
84 views

Postgres logical replication and table rename

We have a table in main DB that is getting logically replicated to another DB called SOR. We need to rename this table, and add a bunch of tables to the publication on the main DB. I tried this ...
hxcb's user avatar
  • 3
0 votes
0 answers
10 views

Postgres superuser privilege disappeared

I've installed Postgres 14 on Ubuntu 22.04. I use pgAdmin as postgres-User to work on it. Everything worked fine until after a few days i realized that the superuser privilege was deactivated for the ...
RafaelG's user avatar
0 votes
0 answers
38 views

How much space required to merge two tables?

I have some large sets of tables that I partition by date. Every day I run a query similar to this to merge the two tables WITH moved_rows AS ( DELETE FROM tableA_20230531 RETURNING * ) INSERT INTO ...
ConanTheGerbil's user avatar