[galaxy-user] cleanup_datasets.py with postgresql 8.1

2013-09-26 Thread Malcolm Tobias

All,

My understanding is that the cleanup_datasets.py under scripts/cleanup_datasets 
should be compatible with 'older' versions of postgresql.  I'm running 8.1 
under CentOS 5.  When I attempt to run the scripts, it fails to clean any data 
sets.  From the logs, I'm noticing messages like:

database_connection contains an unknown SQLAlchemy database dialect: postgresql

In my universe_wsgi.ini I've defined the database_connection as:

database_connection = postgresql://galaxy:@localhost:5432/galaxydb

and am confident it's working as Galaxy works fine, other than this problem 
with deleting older datasets.

The pgcleanup.py script isn't an option, as it requires postgresql =9.1.  I 
noticed yet another version of cleanup_datasets.py under cron which looks like 
it might be compatible with postgres, but am leary of trying it as I'm not sure 
what it means by 1: database directory to clean.  I'm not sure what directory 
to point this to, nor am I confident that just deleting data from the directory 
is the safest thing.

Any suggestions on how to proceed?

Thanks!
Malcolm


-- 
Malcolm Tobias
314.362.1594

___
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using reply all in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

  http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists,
please use the interface at:

  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:

  http://galaxyproject.org/search/mailinglists/

[galaxy-user] cleanup_datasets.py with postgresql 8.1

2013-09-26 Thread Jennifer Jackson
Posting to galaxy-...@bx.psu.edu to give the question better exposure to 
the development community.
Please _remove the galaxy-u...@bx.psu.edu mailing list from all replies_ 
- we want to avoid double posts.



For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

   http://lists.bx.psu.edu/listinfo/galaxy-dev


On 9/26/13 7:29 AM, Malcolm Tobias wrote:


All,

My understanding is that the cleanup_datasets.py under 
scripts/cleanup_datasets should be compatible with 'older' versions of 
postgresql. I'm running 8.1 under CentOS 5. When I attempt to run the 
scripts, it fails to clean any data sets. From the logs, I'm noticing 
messages like:


database_connection contains an unknown SQLAlchemy database dialect: 
postgresql


In my universe_wsgi.ini I've defined the database_connection as:

database_connection = postgresql://galaxy:@localhost:5432/galaxydb

and am confident it's working as Galaxy works fine, other than this 
problem with deleting older datasets.


The pgcleanup.py script isn't an option, as it requires postgresql 
=9.1. I noticed yet another version of cleanup_datasets.py under cron 
which looks like it might be compatible with postgres, but am leary of 
trying it as I'm not sure what it means by 1: database directory to 
clean. I'm not sure what directory to point this to, nor am I 
confident that just deleting data from the directory is the safest thing.


Any suggestions on how to proceed?

Thanks!

Malcolm

--

Malcolm Tobias

314.362.1594



___
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using reply all in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

   http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists,
please use the interface at:

   http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:

   http://galaxyproject.org/search/mailinglists/


--
Jennifer Hillman-Jackson
http://galaxyproject.org

___
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using reply all in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

  http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists,
please use the interface at:

  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:

  http://galaxyproject.org/search/mailinglists/