Обсуждение:
Hi,friends.
How can I use the postgreSQL database after I have installed the postgresql-8.4_8.4.8-0squeeze2_i386.deb?I don't konw which directory it has been released to.
Thanks.
fei
On 10/31/2011 09:45 AM, daflmx wrote: > Hi,friends. > How can I use the postgreSQL database after I have installed the > postgresql-8.4_8.4.8-0squeeze2_i386.deb?I don't konw which directory it > has been released to. It should be on your PATH. Use the "psql" command to interact with it, and start/stop it via the postgresql script in /etc/init.d/ . To find out where psql is installed, use "which psql" at the command prompt. You shouldn't need to manually install a particular deb, anyway; you should be using "apt-get install postgresql" or similar if you want to use a package to install PostgreSQL. -- Craig Ringer
On Sun, Oct 30, 2011 at 7:45 PM, daflmx <daflmx@qq.com> wrote: > Hi,friends. > How can I use the postgreSQL database after I have installed the > postgresql-8.4_8.4.8-0squeeze2_i386.deb?I don't konw which directory it has > been released to. Make sure you've got a postgresql-8.4-client or something like that. sudo su - postgres psql and you're in. If you want to be able to access it as you, then after psql do: create user yournamehere; create database yournamehere with owner yournamehere; \q then exit the postgres shell. Now psql for you as joe user should work.