Re: [Gnumed-devel] removing test data

[Jim Busser]

On 7-Aug-09, at 8:55 AM, Karsten Hilbert wrote:

I have added the following script which will enable people

to delete most test data on a stock v11 database.

I saved the script as

drop_demo_pts.sql 

but when I tried to run it as postgres user gm-dbo I was denied and instead was advised "permission denied to create temporary tables in database "template1"".

When I tried to run it as postgres user "postgres" I got a different error (below):

==================================================================

 

debian:/home/jbusser/v11.rc5/server/bootstrap# psql -h localhost template1 -U gm-dbo -f drop_demo_pts.sql

Password for user gm-dbo: 

SET

BEGIN

psql:drop_demo_pts.sql:25: ERROR:  permission denied to create temporary tables in database "template1"

debian:/home/jbusser/v11.rc5/server/bootstrap# psql -U postgres

psql: FATAL:  Ident authentication failed for user "postgres"

debian:/home/jbusser/v11.rc5/server/bootstrap# exit

exit

address@hidden:~/v11.rc5/server/bootstrap$ sudo su - postgres

address@hidden:~$ psql -U postgres

Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms

       \h for help with SQL commands

       \? for help with psql commands

       \g or terminate with semicolon to execute query

       \q to quit

postgres=# alter role postgres with password '123';

ALTER ROLE

postgres=# \q

address@hidden:~$ exit

logout

address@hidden:~/v11.rc5/server/bootstrap$ su

Password: 

debian:/home/jbusser/v11.rc5/server/bootstrap# psql -h localhost template1 -U postgres -f drop_demo_pts.sql

Password for user postgres: 

SET

BEGIN

psql:drop_demo_pts.sql:25: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "persons_to_delete_pk_identity_key" for table "persons_to_delete"

CREATE TABLE

psql:drop_demo_pts.sql:40: ERROR:  schema "dem" does not exist

debian:/home/jbusser/v11.rc5/server/bootstrap#