Backup and restore postgres database with docker run

August 2, 2023 Nish

Now a days it is common to use database as a service from cloud providers instead of maintaining the local postgres installation. Also there will be times you switch between providers due to some reason such as better cost or better performance. That time you may feel the need to install postgres client to back […]

Read More →

Reset postgres sql auto increment key

November 26, 2022 Nish

Sometimes after you have imported data in to postgres sql database you might find the new inserts are failing as the generated unique sequence keys are conflicting with existing records. You could fix this by setting the new sequence value to the next values by checking the highest number already exists in records. Please run […]

Read More →