#26 Connect to Biblioteq (postgresql db) via local network

[Giorgos Nikolaidis]

Hello,

I'm a ICT Teacher in a greek school and I have installed Biblioteq on a local server (MASTER) as a postgresql database.

I want to install the biblioteq application in several workstations in order to connect have access to the postgresql db and use the biblioteq simultaneously (for example to create book records simultaneously).

I update the biblioteq.conf file and I change the following lines:
[Branch-2]
database_name = library //the name of postgres db
database_type = postgresql
hostname = 192.168.1.20 //the ip of the workstation that postgres runs
port = 5432
ssl_enabled = false

The problem is that I cannot connect to the postgres db. I use the default credentials (xbook_admin as user and passwd).

Your help will be valuable!

Kind regards
Giorgos Nikolaidis
Gymnasio Armenio
Larissa. Greece

[Guess Who]

Hello.

Have you read the Administrator Guide document? I've attached a copy.

Creating and configuring PostgreSQL is something that I expect the user to do. PQ is vast and I cannot cover its installation and configuration without referring to pages and pages of documentation. BiblioteQ supports PostgreSQL and SQLite. While there is essentially nothing to configure for SQLite, PostgreSQL configuration is a responsibility of the user. Remember, BQ is supported on many, many platforms and so it does not provide a means of preparing PQ schemas.

1. Which operating system are you using?
2. Did you read the aforementioned document?
3. Did you execute the postgresql_create_schema.sql script on the 'library' database?
4. Did you configure PQ so that remote access is permitted?
5. Can you access the database locally?

I do not intend to appear dismissive, however, please become comfortable with PQ. Verify that you can access the database locally. PQ provides psql, a terminal-based front-end to PQ. There is also pgAdmin.

Once you have a functional PQ database, BQ will work.

[Guess Who]

Hello. Have you made progress?

[Guess Who]

Unresponsive user. Closing ticket.