[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#659216: what to use in with the database connect url?

On Tue, Apr 24, 2012 at 03:22:40PM +0200, Jelle de Jong wrote:
> I got a working psql command and what to do some smart things with
> librebase, but cant figure out how to use the database url in the wizard!!

It is a "conninfo" string as defined in
which sends you back to
it is a space-separated list of keyword=value pairs.

A more user-friendly prompt is in wishlist:
(I take patches)

> psql -U username -h vps6.server.nl database
> password

For example, the equivalent of this psql command line is:
 host=vps6.server.nl dbname=database
Then enter username and password in the LibreOffice dialogs for that.

You can also hardcode the username (and also password) if you wish so:

 host=vps6.server.nl dbname=database user=HERE_THE_username password=HERE_THE_password

Then, uncomment the "needs password" setting in LibreOffice.

If you enter username and/or password in both the conninfo string
(URL) and the LibreOffice prompts, I don't remember out the top of my
head which one overrides the other one.


Reply to: