Tagged Questions
2
votes
2answers
63 views
Changing PostgreSQL port using command line
My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7).
I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port
...
0
votes
1answer
69 views
Using postgres with the command line without pgAdmin
I started working with PostgreSQL and till now I only had issues with it ( pgAdmin3 issues the most ) now I work a lot with MySQL and sometimes on the command line by just doing
mysql -u ... -h ...
3
votes
1answer
2k views
Pg install: “The database cluster initialisation failed”
(Note: This question has been compeltely rewritten from its original form, so it reflects the actual problem and will help others find a solution to the same issue).
I still haven't been able to ...
2
votes
1answer
269 views
PostgreSQL: Change default port used by utilites like psql, createdb, etc
I have 2 instances of PostgreSQL running on some servers. One on the default port (5432) and the other instance on port 5433. Some users (and processes) only need access to the second instance (5433) ...
38
votes
7answers
68k views
How do I list all databases and tables using psql?
I am trying to learn PostgreSQL administration and have started learning how to use the psql command line tool.
When I log in with psql --username=postgres, how do I list all databases and tables?
I ...
