[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] removing test data
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] removing test data |
Date: |
Sat, 8 Aug 2009 09:02:26 +0200 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
On Fri, Aug 07, 2009 at 11:41:06PM -0700, Jim Busser 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"".
You need to run it against the database you want to drop
patients from.
> postgres=# alter role postgres with password '123';
Don't do that. It will prevent Debian from doing database
maintenance.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- [Gnumed-devel] removing test data, Karsten Hilbert, 2009/08/07
- Re: [Gnumed-devel] removing test data, Jim Busser, 2009/08/07
- Re: [Gnumed-devel] removing test data, Jim Busser, 2009/08/08
- Re: [Gnumed-devel] removing test data,
Karsten Hilbert <=
- Re: [Gnumed-devel] removing test data, Jim Busser, 2009/08/08
- Re: [Gnumed-devel] removing test data, Karsten Hilbert, 2009/08/08
- Re: [Gnumed-devel] removing test data, Jim Busser, 2009/08/08
- Re: [Gnumed-devel] removing test data, Karsten Hilbert, 2009/08/08