189 reputation
28
bio website linkedin.com/in/robbednark
location Portland, Oregon, USA
age 45
visits member for 2 years, 5 months
seen Jul 21 at 21:05

Software Developer, most enthusiastically in Python and Django.


May
28
awarded  Notable Question
Dec
8
awarded  Popular Question
Oct
2
awarded  Notable Question
Jul
2
awarded  Popular Question
May
8
awarded  Popular Question
Sep
6
comment How to list all views in SQL in PostgreSQL?
Thanks @Phil. However, that command returns 128 rows, whereas \dv returns 57 rows. It seems to be giving me system views as well, like "tables", "columns", "domains", "pg_role", etc. How do I get just the views that I created?
Sep
6
asked How to list all views in SQL in PostgreSQL?
Jul
27
revised How to verify postgresql db restore from pg_dump file
Added sequence link that @ocharles gave in his comment.
Jul
27
suggested suggested edit on How to verify postgresql db restore from pg_dump file
Jul
25
comment Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
Thanks @Erwin_Brandstetter! Another excellent answer from you, I sure appreciate it.
Jul
25
accepted Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
Jul
25
comment How to rename a Postgresql cluster?
Thanks @Erwin_Brandstetter! Nice detailed answer with useful link to Martin Pitt's architecture. I will give your answer a try.
Jul
25
accepted How to rename a Postgresql cluster?
Jul
24
comment How to rename a Postgresql cluster?
@a_horse_with_no_name, I added pg_lsclusters output above. I'm new to this, but I believe you can have multiple clusters, and you have to identify which cluster you are talking to by its name (or maybe directory name, I'm not sure).
Jul
24
revised Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
Added update about what I found using pg_dropcluster
Jul
24
revised How to rename a Postgresql cluster?
Added pg_lsclusters output, and also added spacing to make more readable.
Jul
24
revised Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
Added a possible solution that I just found.
Jul
24
asked Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
Jul
24
asked How to rename a Postgresql cluster?
Jul
18
awarded  Supporter