2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Hey guys,
I have patroni and ETCD to manage my postgreSQL cluster. However, replication sometimes doesn't work, however I put all the parameter needed for replication, and also they both not synced together at all. any solution for that pls?? Pls anyone DM me if having experience in patroni pls, Thanks...
It's not unacceptable, I just sincerely believe that we can (and should!) do better than some sophisticated bot ;-)
Читать полностью…
I reckon @standart_soft got the message... right, @standart_soft ?
Читать полностью…
Isn't there something like lmgtfy.com for ChatGPT? Pasting walls of text with probably questionable quality shouldn't be our level here IMHO.
Читать полностью…
Indeed, the docs are well written and always the most up to date documentation you can find.
A member of this channel setup another channel that provides links to PostgreSQL documentation / tips and tricks. You can browse through them here: /channel/postgresql_lib
And the original documentation is here for free:
https://www.postgresql.org/docs/
You'll need to:
- disconnect the secondary from the primary
- upgrade the secondary
- stop the secondary
- upgrade the primary
- stop the primary (or use pg_start_backup to freeze the data folder)
- use rsync to sync the data folder from the primary to the secondary
- rejoin the primary and secondary and start everything back up
u sure the database is listening to this port on this host? recheck your configuration settings
Читать полностью…
Hi everyone, could you suggest the best approach to upgrade db if I am using standby?
Читать полностью…
The first step would be to answer the question you've been asked...
Читать полностью…
Like i can use replication slot instead of wal keep segment if I have my wals keep sending from one server to another, and vice versa I can use wal keep segment instead of replication slot
Читать полностью…
Let's say the _outcome_ is the same in case the replica gets disconnected: WAL segments are kept around for some time.
But the whole reasoning behind it and the purpose is wildly different, so yeah, they're somewhat related (as in "they affect WAL recycling"), but very different.
The instructions written by the bot still need to be understood. For me, this is the same text as technical documentation or examples from a selection of search engines.
Читать полностью…
OK, I'll delete the message if it's unacceptable. I sometimes use gpt, it answers simple questions, or helps to take the first step.
Читать полностью…
I would suggest just to ban users translating GPT-crap.
Читать полностью…
I am new here
How can I start postgreSQL from beginning?
ChatGPT 4:
Welcome! Getting started with PostgreSQL is a great choice for managing databases. Here’s a step-by-step guide to help you begin:
▎1. Install PostgreSQL
▎On Windows:
- Download the installer from the [official PostgreSQL website](https://www.postgresql.org/download/windows/).
- Run the installer and follow the prompts to install PostgreSQL and pgAdmin (a graphical interface).
▎On macOS:
- You can use Homebrew:
brew install postgresql
sudo apt update
sudo apt install postgresql postgresql-contrib
sudo yum install postgresql-server postgresql-contrib
brew services start postgresql
sudo systemctl start postgresql
postgres user (default superuser):sudo -i -u postgres
psql
psql), you can create a new database:CREATE DATABASE mydatabase;
\c mydatabase;
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100)
);
INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
SELECT * FROM users;
I am new here
How can I start postgreSQL from beginning
No Video Lectures
Provide me only book according to 2024 era edition
If you upgrade primary and secondary the timelines will diverge, so there is no way to make indipendent upgrades
Читать полностью…
Pg_upgrade is fine do we start upgrading first to standby after revoke connection from primary or we setup new standby after upgrade primary
Читать полностью…
sometimes there is a problem in binding the host ip, try using the other ip assigned to your machine instead
Читать полностью…
https://www.postgresql.org/docs/current/pgupgrade.html#PGUPGRADE-STEP-REPLICAS
Читать полностью…
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?
Читать полностью…
psycopg2.OperationalError: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
wal_keep_segments is more like a safety net for non-slot/non-archive replication setups.
If you can't use an archive and can't afford an occasional basebackup after longer outages, you're better off with a replication slot. At the risk of running out of disk space...
Btw,is there any Postgres certification that one can do?
Читать полностью…