Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

populate postgres
 
Notifications
Clear all

populate postgres

2 Posts
2 Users
0 Reactions
2,207 Views
(@moserwi)
Posts: 7
Active Member
Topic starter
 
[#6721]

Hi,

I do have a clean install site (projeqtorV8.4.4)and expect the database to be populated after "continue"

############################
cat parameters.php
/dev/null
sudo service postgresql reload
######################
nmap -sT 127.0.0.1
PORT STATE SERVICE
5432/tcp open postgresql
######################
postgresql-11 log:
2020-05-20 17:39:03.373 CEST [32519] projeqtor@projeqtor FEHLER: Relation »parameter« existiert nicht bei Zeichen 15
2020-05-20 17:39:03.373 CEST [32519] projeqtor@projeqtor ANWEISUNG: select * from parameter where (idUser is null and idProject is null)
2020-05-20 18:09:48.967 CEST [4667] [unbekannt]@[unbekannt] LOG: konnte Daten vom Client nicht empfangen: Die Verbindung wurde vom Kommunikationspartner zurückgesetzt
2020-05-20 18:09:48.967 CEST [4667] [unbekannt]@[unbekannt] LOG: unvollständiges Startpaket
#######################
No a single table is create and it looks like the sql-scripts are not compatible with pgsql
#######################

Question: where is the bunch of sql scripts that I can use to pupulate the db manually??

OK I bet there is a solution: proceed with mysql and migrate the database to pgsql thereafter. BUT I am sure that is not whst i, and you, want.

willi


 
Posted : 20 May 2020 20H19
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

With postgreSql you have to create db manually.
You also have to create a db user user with all access rights to this DB.
Then define credentials to DB in configuration screen.

On continue, DB is not populated yet.
You reach login screen and need to connect as admin/admin
This will populate the DB.

Question: where is the bunch of sql scripts that I can use to pupulate the db manually??

You must absolutely not do this.

OK I bet there is a solution: proceed with mysql and migrate the database to pgsql thereafter. BUT I am sure that is not whst i, and you, want.

Migration from MySql to PostgreSql is not so easy...


 
Posted : 25 May 2020 14H06
Share:

Scroll to Top