- 12
- 33 751
databasetorque
United States
Registrace 22. 02. 2019
VM in a few minutes using multipass (Apple M1)
This short video shows how to use multipass to create an Ubuntu VM in a few minutes on MacBook Pro M1.
multipass.run/
multipass.run/
zhlédnutí: 605
Video
Pgbackrest configurations | Tuning | Streaming replication
zhlédnutí 3,9KPřed 2 lety
This video explains some of the important pgbackrest configurations options that you need to have for stable replication and keep the primary server highly available. Pgbackrest is one of the commonly used tools to manage postgreSQL backups and implement streaming replications. It is a feature rich tool. For more details: pgbackrest.org/command.html
How to create a signed url AWS S3 // Sharing an object with a presigned URL
zhlédnutí 235Před 2 lety
All objects in S3 by default are private. Only the object owner has permission to access these objects. However, the object owner can optionally share objects with others by creating a presigned URL, using their own security credentials, to grant time-limited permission to download the objects. In this video, it demonstrate how to generate presigned url using python.
You need to check your EDB Postgres, RIGHT NOW for redwood setting!
zhlédnutí 131Před 2 lety
This video demonstrate how redwood setting changes EDB Postgres behavior by going through an example.
Troubleshooting a failure event of SQL Server Always On Availability Group
zhlédnutí 6KPřed 2 lety
This video explains on how to troubleshoot AG failure event of SQL Server and find out the root cause for the failure.
PostgreSQL roles, schema and security
zhlédnutí 18KPřed 3 lety
In this video, I explain the concept of postgres roles, schema and manage security using them with demos.
managing pgbouncer
zhlédnutí 556Před 3 lety
This video explains the management aspect of pgbouncer by using its admin console. # pgbouncer docs www.pgbouncer.org/ # quick start guide on how to setup pgbouncer databasetorque.com/postgres-how-to-setup-pgbouncer/
Assign CPU Resources to Pods
zhlédnutí 124Před 3 lety
This demo shows how to assign a CPU request and a CPU limit to a container/Pod. Containers cannot use more CPU than the configured limit. Provided the system has CPU time free, a container is guaranteed to be allocated as much CPU as it requests.
How To Install and Initialize EDB Advanced Server 12 (Postgres)
zhlédnutí 2,7KPřed 4 lety
In this video, learn how to install and initialize EDB Advanced Server 12 (PostgreSQL). This shows how to set custom paths for the data and WAL files with the full installation and initialization of the cluster. How to mount a filesystem in CentOS czcams.com/video/aCorGIQCxl4/video.html EDB official site www.enterprisedb.com/ PostgreSQL official site www.postgresql.org/
How to mount a filesystem in CentOS
zhlédnutí 644Před 4 lety
In this video, learn how to mount a filesystem in CentOS 8.0
How To Create a VM in VMware ESXi Hypervisor
zhlédnutí 13Před 4 lety
In this video, learn how to create a VM in VMware ESXi hypervisor.
How to download EDB Advanced Server
zhlédnutí 529Před 4 lety
In this video, learn how to download EDB Advanced Server (EDB version of Postgres) EDB official site: www.enterprisedb.com/
Is that correct the replica got wal from master through archive_push and archive_get of pgbackrest?
Can you make one where there's no centralized backup server, but instead it exists in prim or stby? This usecase is useful if we don't hace the means to provide more than 2 servers
Nice. I have one query, I have created a new database (DB1) and new user(User1), Now i want to provide the DB OWNER access to DB1 for this new user (User1), Please guide on this.
If pg_wal is getting filled everyday and size is increasing day by day, how to overcome it?
Hi Sir, Do you take any postgres trainings ?
Do you mean whether I conduct PostgreSQL training? I do not conduct training as of now.
@@databasetorque4253 Thanks Sir, can you upload few more videos of Postgres ,,, 😀
Someone know if i could restring the exportation of a shapefile in qgis from pgadmin?
if we grant the create schema , that user can truncate and drop access ? even we didn't grant for drop.
Why I cannot open multipass, before this I’ve tried delete some directory/file and learning some command in this app. But out of sudden I cannot run it open multipass and
what we can do to bring the ag online from offline due this fump generation error??
How about this error while testing same as you said psql: error: FATAL: Peer authentication failed for user "user1"
great, thank you
Very useful sir, thanks you
I have accidently deleted my database in posgressql can it be restored back .I don't have backup
Superb, Thank You !! 🙏😊👍
Thanks for this video! It helped me a lot and was explained with easy examples. As a PostgreSQL beginner, it's not always easy to understand the basics of the underlying security. (Even if I know some other relational database server.)
Very clear on the user and role concept. Great job.
Awesome , Excellent commanding on subject
Thank you databasetorque , where are other videos as mentioned.
creating directory /pgdata/data ... initdb: could not create directory "/pgdata": Permission denied any clue to solve this?
Good explanation! Helped a lot to figure out. Keep going on and posting more useful videos, good luck!
Simply and clearly explained. Thanks.
crystal clear -- thanks
Very usefull video. Thank you !
Can you please make a video about postgresql schema and how to assign privileges in deep
sure. will do
I posted a new video. Please check it out. thanks!
Very good presentation.
Can i install it on solaris 11.3? If yes from where to download the binaries
I do not see Solaris OS on the download page of enterprisedb site. Probably you need to chat with them about this requirement. FYI, if you want to download Postgres Advanced Server version, you need to sign up to their site first. Thanks
Very good and clear explanation
Nice video tutorial. Can you do a video tutorial on how to configure a 2 node postgresql advance server with patroni HA and etcd
Do you mean on Kuberenetes? If so, sure, I can do