Hi Amos Since the PostgreSQL database stores much more than the links to and previews of the individual datasets, you need to restore it from your PostgreSQL backup file. Hans-Rudolf On 02/25/2016 08:53 PM, Raphenya, Amogelang wrote:
Hi All,
Our server hard drive failed and we lost the database which was running galaxy instance.
But we did NOT loose all the data i.e all the files are there under the*/galaxy-dist *directory. * * Is there a way to reconstruct the database using the data itself.
Please help.
/ / /*Amos Raphenya* / /Bioinformatics Software Developer/ /Department of Biochemistry & Biomedical Sciences/ /McMaster University, MDCL //2317/ /p: (905) 525-9140//ext: //22787/ /a:1280 Main St W.,Hamilton, Ontario, Canada L8S 4K1/ /e: raphenar@mcmaster.ca <mailto:raphenar@mcmaster.ca> / /skype:amos_raphenya/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Hi Amos, As Hans-Rudolf said, if you really have lost the database and its backups, there is not much you can do. If you have just a few very valuable datasets that have to be recovered, I would look at the file dates (guided by the automatically incremented dataset numbers), sizes, and look at the data to check the contents (everything will be named *.dat as the extension, other than complex datatypes). Peter On Fri, Feb 26, 2016 at 9:12 AM, Hans-Rudolf Hotz <hrh@fmi.ch> wrote:
Hi Amos
Since the PostgreSQL database stores much more than the links to and previews of the individual datasets, you need to restore it from your PostgreSQL backup file.
Hans-Rudolf
On 02/25/2016 08:53 PM, Raphenya, Amogelang wrote:
Hi All,
Our server hard drive failed and we lost the database which was running galaxy instance.
But we did NOT loose all the data i.e all the files are there under the*/galaxy-dist *directory. * * Is there a way to reconstruct the database using the data itself.
Please help.
/ / /*Amos Raphenya* / /Bioinformatics Software Developer/ /Department of Biochemistry & Biomedical Sciences/ /McMaster University, MDCL //2317/ /p: (905) 525-9140//ext: //22787/ /a:1280 Main St W.,Hamilton, Ontario, Canada L8S 4K1/ /e: raphenar@mcmaster.ca <mailto:raphenar@mcmaster.ca> / /skype:amos_raphenya/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Hi To follow up on Peter's suggestion: It might be worth trying to make 'Galaxy Data Libraries' for all the old individual datasets in your new Galaxy installation. This way, you will have sort of easy access to the old datasets in you new set-up. Since the datasets are in distinct folders (database/files/000, database/files/001, database/files/002, etc), you can use the option: "Upload files from filesystem paths". It will 'auto-detect' the file format for you. Though this will take a very, very long time, since you have up to 1000 files per directory (you might wanna split the directories into smaller chunks). Also, it won't work with complex datatypes. Hans-Rudolf On 02/26/2016 10:18 AM, Peter Cock wrote:
Hi Amos,
As Hans-Rudolf said, if you really have lost the database and its backups, there is not much you can do.
If you have just a few very valuable datasets that have to be recovered, I would look at the file dates (guided by the automatically incremented dataset numbers), sizes, and look at the data to check the contents (everything will be named *.dat as the extension, other than complex datatypes).
Peter
On Fri, Feb 26, 2016 at 9:12 AM, Hans-Rudolf Hotz <hrh@fmi.ch> wrote:
Hi Amos
Since the PostgreSQL database stores much more than the links to and previews of the individual datasets, you need to restore it from your PostgreSQL backup file.
Hans-Rudolf
On 02/25/2016 08:53 PM, Raphenya, Amogelang wrote:
Hi All,
Our server hard drive failed and we lost the database which was running galaxy instance.
But we did NOT loose all the data i.e all the files are there under the*/galaxy-dist *directory. * * Is there a way to reconstruct the database using the data itself.
Please help.
/ / /*Amos Raphenya* / /Bioinformatics Software Developer/ /Department of Biochemistry & Biomedical Sciences/ /McMaster University, MDCL //2317/ /p: (905) 525-9140//ext: //22787/ /a:1280 Main St W.,Hamilton, Ontario, Canada L8S 4K1/ /e: raphenar@mcmaster.ca <mailto:raphenar@mcmaster.ca> / /skype:amos_raphenya/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
participants (3)
-
Hans-Rudolf Hotz -
Peter Cock -
Raphenya, Amogelang