The first error that I've got, I described on Github, but Tom asked
me to send an e-mail here.
Well, I followed his tip and I tried to add the database using the
following steps , however without success again, unfortunately.
First of all, I tried to run the command without database called "pycsw"
and it returned an error saying "database "pycsw" does not exist" and
below " Database tables already exist" (image
table_does_not_exist_but_it_exist.png ). For that reason, I did not
understand what happened.
Then I tried to create the database manually and run the command again.
In this time, I got the following error: "language "plpythonu" does not
exist" (image plpythonu_does_not_exist.png ).
So I tried to install the plpythonu and create the extension with the
following links  and . After that, I tried to run the command
again and I got the same error again.
Re: Install and execute pycsw with a PostgreSQL with PostGIS
Hi Rodrigo: thanks for the info. For PostgreSQL/PostGIS installs, the
following are required:
- PostgreSQL database exists, with PostGIS enabled
- plpythonu is not required for PostgresSQL enabled with PostGIS
- the pycsw configuration is pointing to the PostgreSQL with PostGIS install and
correct database name (which has been PostGIS-enabled). pycsw will
create the records table
- you need psycopg2 installed (see requirements-pg.txt)
Then, running pycsw-admin.py -c setup_db -f default.cfg will then simply
create the 'records' table. I was able to set this up against the
docker image, for example, with success.
Can you ensure that your database setup is per above, and that the pycsw
configuration is pointing to that database?
On Thu, Mar 28, 2019 at 8:13 AM Rodrigo M. Mariano
<[hidden email]> wrote: