The latest articles on DEV Community by Wajid Saleem (@wajid_saleem_15f4c7513ce5). https://dev.to/wajid_saleem_15f4c7513ce5 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1495742%2F6c8a75e3-642e-4fa3-803d-62950606b740.jpg https://dev.to/wajid_saleem_15f4c7513ce5 en Wajid Saleem Fri, 31 May 2024 06:51:20 +0000 https://dev.to/wajid_saleem_15f4c7513ce5/mastering-postgresql-backups-with-pgdump-2kh3 https://dev.to/wajid_saleem_15f4c7513ce5/mastering-postgresql-backups-with-pgdump-2kh3 <p>Backups are critical in database management, and PostgreSQL offers a powerful tool for this purpose: pg_dump. This guide will walk you through using pg_dump to create efficient and reliable backups.</p> <p>What Is pg_dump?<br> pg_dump is a command-line utility for creating backups of a PostgreSQL database. It can export an entire database or specific parts, such as individual tables or schemas. The output can be:</p> <p>SQL Script: A plain-text file with SQL commands to recreate the database.<br> Directory-Based Archive: A set of folders designed to be portable across architectures, to be restored using pg_restore.<br> pg_dump ensures consistent backups even when the database is in use.</p> <p>pg_dump [options] [dbname]</p> <ul> <li>Dump a Database Into an SQL Script</li> </ul> <p>pg_dump -U admin -d company -f company_backup.sql</p> <ul> <li>Dump a Database With Create Command</li> </ul> <p>pg_dump -U admin -d company -f company_backup.sql --create</p> <ul> <li>Dump a Database Into a Directory-Format Archive</li> </ul> <p>pg_dump -U admin -d company -F d -f company_backup</p> <ul> <li>Export Data Only</li> </ul> <p>pg_dump -U admin -d company -f company_backup.sql --data-only</p> <ul> <li>Export Schema Only pg_dump -U admin -d company -f company_backup.sql --schema-only</li> </ul> <p>*Include Only Specific Schemas</p> <p>pg_dump -U admin -d company -n 'p*' -f company_backup.sql</p> <ul> <li>Include Only Specific Tables</li> </ul> <p>pg_dump -U admin -d company -t '<em>order</em>' -f company_backup.sql</p> <p>pg_dump is a versatile and powerful tool for PostgreSQL backups. Understanding its options and commands allows you to create precise and effective backups tailored to your needs. For more advanced database management, consider tools like DbVisualizer, which simplify the process with a graphical interface.</p> Wajid Saleem Wed, 15 May 2024 02:31:24 +0000 https://dev.to/wajid_saleem_15f4c7513ce5/installation-of-postgresql-on-rocky-linux-4h00 https://dev.to/wajid_saleem_15f4c7513ce5/installation-of-postgresql-on-rocky-linux-4h00 <p>Run the following commands on your rocky Linux to just get simple installation of postgres</p> <p>dnf module list PostgreSQL # to check the modules of postgres available in the operating system. </p> <p>sudo dnf module enable postgresql:15 #to enable the default stream of postgress Hint : change the version you want to use as default like 12,13 or 14 </p> <p>sudo dnf install postgresql-server #it will install the dependencies and packages of postgres </p> <p>sudo postgresql-setup --initdb #to initialize db using the script ( postgresql-setup) downloaded with all the packages in previous commands</p> <p>sudo -i -u postgres #To go to postgres default user created when the packages installed. </p> <p>psql #after </p> <p>create user repuser replication; #To create user </p> programming opensource postgres