Відео

good tutorial thanks

Buen video .. quiero sacar un backup y me sale el error ... Pg_dump: el esquema 2201 no existe... Portgresql-11.?

Really good, straight to the point and concise explanation of how to export a PostgreSQL DB!

thanks

So why use pg_dump at all if you can just use pg_dumpall without the -g parameter and have all the data and user objects in a single file?

Mine just refuses to produce the file on dump though. Frustrating af.

This was very helpful and calmly and clearly explained with high quality audio and video. Thank you SO much for that.

Gretae Video!

thanks :)

Thanks, that was very helpful

So to recap: If I have a postgres instance with 1 self created DB and I want to export both the DB and all the users, I use pg_dumpall without the -g flag? If I then import the dump file to a new postgres instance, will it overwrite the pre-existing default postgres schemes, i.e. information_schema, pg_catalog, pg_toast, public?

Hello Guys, I am an Oracle/SQL Server DBA. Currently I've a requirement for configuring postgresql database. Which am new to this environment and want to manage the database(Backup, Restore, Health Check, Alerts monitor). Kindly assist me on this

Helpful! Thanks

o melhor!

in result set of pg_stat_statements max_exec_time records e.g. 19sec while mean_exec_time records 0.7sec there is huge difference for calls around 500...I couldn't find the cause of this huge difference in time..could you please help

really a excellent tutorial , any best practice for wal files to be archived,

such a simple and clear turorial.

Great videos 👍🏼

Five years old but still very good.

nice explanation tq so much

Well explained, thanks. In some managed postgres DBs you can't run dumpall, because it needs super user permission. How can I dump users in that case?

Thanks do you viedo for pg restore ?

Very useful. Thanks. Do you offer PostgreSQL training?

Thanks, that's really helpful. Any plans to make a video covering how to create a backup from e.g a remote postgres running on AWS RDS onto a local backup machine? I'm trying to understand how I could automate daily backups to my extra linux machine.

How to create these 2 nodes ?

Loved the simple no-bullshit kinda tutorial! Thanks

What I need: Logical replication from Posgres on Windows to Postgres in docker container on Linux

Very well explained , how can we add a table to an existing replication slot.

my postgresql.conf file was actually located in /etc/postgres/10/main/ the directory outputted by running the 'SHOW data_directory' command only had a postgres.auto.conf file

Thanks for the video. Its really clear. But why creat database Baltimore in 9.5, why not just restore from the logical backup from 9.4?

this replication is synchronous? is possible write some things on node 2 and automatically replica for node 1 or only writing on node 1 for node 2?

You take requests?

can u know how to do postgresql replication in windows machine

I've followed everything step by step (pausing and playing the video), and still can't get machine 2 to replicate. I've tried 3 times now.

Thank you, clearly tutorial.

Awesomely explained, crisp and clear :+1:

Does anyone know where I can download a 9.0 installer for Windows?

Thanks, man. You fixed my problem!

I was trying to automate through Ansible, but wasn't able to set the Setup, now I'm, Thank you very much!!

Hi! in 3:54 of your video may I ask how did you exit inside .pgpass after entering hostname:port:postgress...?

greate Job Man your awsome

Can you create a new schema in node2 (subscriber), and read data from the subscription "employee" table?

Is it possible to login PostgreSQL with Windows Authentication. Please help with your answers.

Simple but High thinking to do in couple of minutes logical replication....I will try...

hi @PostgresCourse.com , is it possible if I create subscription to different schema name? on your tutorial, the schema name is the same which is public. But I want to replicate the master "public" schema to my slave "not-public" schema (schema name is different). is it possible to do that?

Hello, very good tutorial. I see that the replica is active - passive. I would like to know if there is a way for it to be active - active.

Thanks for making the information available.

Thanks for sharing this excellent tutorial. ¿Would you please make one about backup plans, and backups having in mind replication?

awesome; short, direct, clearly stated. THANK YOU!

is it possible to replicate only 1 or 2 tables and not all the tables? for example if we have 10 tables in node1 server but only 2 tables to be replicated to node2 server using this approach?