On Fri, Oct 14, 2011 at 06:19:50PM +0000, Blanco, Jose wrote:
> Do you mean get into postgres so you can see the tables and query them using 
> SQL?  If so, I use this command:
> 
> $  psql -U dspace-prod

More generally:  -U specifies a DBMS user, so you could look in
config/dspace.cfg for the value of db.username and use that.  You may
also need to specify the database name, which will be the last element
of db.url.

So if:

  db.url = jdbc:postgresql://localhost:5432/ourstuff
  db.username = melvin
  db.password = secret

Then the command would be:

  psql -U melvin ourstuff

and you'd enter 'secret' when asked for the password.

-- 
Mark H. Wood, Lead System Programmer   [email protected]
Asking whether markets are efficient is like asking whether people are smart.

Attachment: pgpSoDmX9lDUQ.pgp
Description: PGP signature

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to