497 reputation
512
bio website manavgoel.net
location India
age
visits member for 3 years, 1 month
seen Mar 21 at 6:05

I am a freelance developer with specialisation in python web application.


Oct
8
awarded  Good Question
Sep
24
awarded  Autobiographer
Sep
9
awarded  Notable Question
Jul
2
awarded  Curious
Dec
22
awarded  Popular Question
Sep
13
awarded  Yearling
May
22
comment Usage of foreign key when the referenced table data will not change
Thanks for the answer. What are these option1 and 2 tables?
May
22
asked Usage of foreign key when the referenced table data will not change
May
16
awarded  Notable Question
Dec
9
accepted Postgres Backup queries on AWS after reading Postgres docs
Dec
3
comment Many To Many Relationships
Agreed, it depends on the use case. I just mentioned it so that op gets a clear picture of this type of relationship. :)
Dec
3
comment Many To Many Relationships
Also both the foreign keys should be part of primary key so that no record gets duplicated and it also helps performance when getting data back.
Dec
3
comment Postgres Backup queries on AWS after reading Postgres docs
Regarding pg_start_backup command, I should issue it then take snapshot and then issue pg_stop_backup. Right?
Dec
2
accepted Database design with different user roles connected by different relationships to one organizaiton table
Dec
2
asked Postgres Backup queries on AWS after reading Postgres docs
Nov
19
comment Moving postgresql data to different drive
Thanks. To change directory I just needed to run postgres -D /location after following steps mentioned by you. :)
Nov
19
accepted Moving postgresql data to different drive
Nov
19
awarded  Commentator
Nov
19
comment Moving postgresql data to different drive
In 4th point, what do you mean by 'This is usually defined through a commandline parameter...'?
Nov
19
asked Moving postgresql data to different drive