• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Postgres DB Scripts Best Practices

 
Joe Harry
Ranch Hand
Posts: 10128
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm new to using Postgres database servers and I'm currently trying to set up some scripts that will go through the release process. I have once done that with Oracle databases and all I remember doing is create a simple file with all the create table statements and hand that over comfortably to a DBA who would take care of the appropriate user under which this script would be run, giving permissions for schema access and so on. But this time I got to do that all by myself! As I'm not a DBA and I could not say what pitfalls are there if I come up with a simple script. All what I have in mind for the script is the following:



I'm not sure how permissions, access rights work. Can anyone throw some light on it?
 
Kishor Joshi
Ranch Hand
Posts: 674
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
so your questions is related to make a backup of postgres db data ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic