I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well):

LibreOffice Base data source selection

The following syntax (localhost:5432=<database name>; database name worktime) doesn't work:

enter image description here

When I try to test the connection on the next page, I get the following error:

Error in database URL 'sdbc:postgresql:localhost:5432=localhost':
invalid connection option "localhost:5432"

What is the correct syntax for the datasource URL?

  • I may not ask an SU question especially for that, so I ask you personnally: what do you do when you plug Libre Office into Postgresql ? what kind of help, usefulness does this association offer ? Is it only for editing the content of the database ? – Stephane Rolland Jan 28 '13 at 13:09
  • 2
    @StephaneRolland: LibreOffice provides a graphical interface for input and editing of data in the tables as well as a query builder, among other features that make interfacing with the database easier. – bwDraco Jan 28 '13 at 14:46

Ever Forward will answer your question:

This is not an Internet URL, but it functions similarly. You now need to tell LibreOffice to connect to a specific database on a specific computer:

dbname=mydb host=localhost

Use the name of your database in the dbname part. I used localhost for the host part, since PostgreSQL is on the same computer, but I would need to change that in the event that I want to connect from a remote computer.

| improve this answer | |

I know this Q is answered.. but here is more data information for someone who may stumble across this topic.

Another form of datasource URL is in the format of:

dbname=postgres hostaddr= port=5433 user=db_user password=libreoffice

I needed the above, because the default port used by LibreBase is 5432, but I needed 5433.

This URL format is discussed at http://ask.libreoffice.org/question/459/generic-form-of-url-for-postgresql/

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.