#pg
3 posts tagged pg. Clear filter
-
How to Find Postgres Log File and Postgres Data Directory from PSQL
If you want to find the location of your log file in Postgres, you'll need to hop into a Psql session.. psql dbname Then it's as simple as running.. show data\directory ; Which will output the data...
-
How to Import/Export a Database from One Heroku App to Another Heroku App
Heroku is awesome! Let's say we want to copy a production database to a staging database. We can use the pg:backups:restore command to accomplish this. Here is an example. For the source database...
-
How to Enable UUIDs in Postgres
The first thing you'll need to do is enable the extension create extension "uuid-ossp"; To test that it's working select uuidgeneratev1(); For more info on which version of the algorithm you should...