AI Zone Admin Forum Add your forum

NEWS: Chatbots.org survey on 3000 US and UK consumers shows it is time for chatbot integration in customer service!read more..

Using Postgres as File Server not creating tables in Database
 
 

Hi,
I was looking at esoteric CS manual and also topic Using Postgres as File Server.

Started CS with command:

./BINARIES/ChatScriptpg local pguser="hostaddr=127.0.0.1 port = 5432 user = postgres password = somepassword " 

Actually i managed to get correct stdout in CS console:

Postgres enabledFileSystem routed to hostaddr=127.0.0.1 port 5432 user postgres password somepassword 

But checking Postgres server showed me that no users db created and no tables created in postgres DB as well.

postgres=# \c users
FATAL:  database "users" does not exist
Previous connection kept
postgres
=# \dt
No relations found

Actually I’ve used Postgres bot, and with it connection was established with the same credentials - so they are correct. Also I installed all packages for postgres which you’ve mentioned in manual. And also changed in pg_hba.conf the local validation from peer to trust.
Could you please suggest what could be the reason?

 

 

 
  [ # 1 ]

And this is really strange. When I was using provided Postgres bot, not only connection to PG from CS was established but I was also able to create and drop tables using it. I mean CS really can interact with Postgres. But for some reason it is not writing any data about users to database, when I try to use it as a file server. I already checked everything - using with and without password users in credentials for PG, but still don’t have creating database *users* in postgres when i run CS binary with parameter pguser=“hostaddr=127.0.0.1 port = 5432 user = postgres password = somepassword “, but I mentioned that it keep writing user’s state in CS inside topic_useranme_botname.txt file inside USERS folder.
Could please anybody, who already succeeded with using CS with PG as a fileserver help me? How can I actually check in Postgres that CS is writing data inside database? Maybe I was doing it wrong before checking *\c users* inside PG console and it should be done somehow else? Will be very grateful for any help. Thanks.

 

 
  login or register to react