By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

how to run postgresql on debian terminal

P: 6
I installed postgresql on debian and i want to run it on the terminal.some body can do me that favour
Mar 5 '08 #1
Share this Question
Share on Google+
4 Replies


Expert 100+
P: 700
To start server you can use command
Expand|Select|Wrap|Line Numbers
  1. pg_ctl start
  2.  
To connect to database you can use psql client
Expand|Select|Wrap|Line Numbers
  1. psql database_name
  2.  
Mar 5 '08 #2

P: 2
follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database
8. type exit to close postgresql database
Mar 11 '08 #3

P: 2
follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database
8. type exit to close postgresql database
Mar 11 '08 #4

P: 4
Hi, I am using Debian etch with postgresql database. I used this procedure for start postgre database on my terminal
follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database
8. type exit to close postgresql database
Mar 11 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.