Quote:
Originally Posted by _dave_
I always have the "invalid" popup, but it works OK after I click thru it.
You need manually create the tables for postgresql. There is a file "schema.postgres.sql" IIRC somewhere in the fpdb folders - find it.
Open pgAdmin, right click and create a new database. I just set the owner to postgres, left everything else default. I named it "fpdb"
then right click on the (empty) fpdb database, hit the SQL Query tool icon (like a pencil & pad, with "SQL" written - open the schema file and execute it.
Done with pgadmin, I edited the fpdb.conf so the dbformat(?) to 3 rather than 2, username postgres, dbname fpdb, and it seems to be working... early days yet tho, and I haven't been near the hud yet...
Yes, this is all good advice.
For now, if you use PostgreSQL, you must create a PostgreSQL database in pgadmin or using the command line thingie.
If you have not created a db, you get this error in the terminal window when you try to run fpdb:
_mysql_exceptions.OperationalError: (1044, "Access denied for user 'mythtv'@'192.168.1.102' to database 'fpdbfarts'")
When you see the "invalid" popup, you need to select the create or recreate tables item in the database menu. (or create them in pgadmin as _dave_ suggested--I have created them both ways and they worked OK)
If you have created a database, then fpdb should create tables just fine when you select the create or recreate tables menu item. But creating the tables in pgadmin should work fine, too.