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
http://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PQCONNECTDB,
which sends you back to
http://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PQCONNECTDBPARAMS;
it is a space-separated list of keyword=value pairs.
A more user-friendly prompt is in wishlist:
https://bugs.freedesktop.org/43369
(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.
--
Lionel
Reply to: