These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

[Retribution 1.1] Postgresql Datadump
Author
Previous Topic Next Topic
Dei
Cosmic Core Industries
#1 - 2012-11-26 17:20:11 UTC  |  Edited by: Dei
Here is a Postgres backup of the SDE (updated from Inferno).

Things to note:

  • xMin is a reserved word, so the map tables now have an xMins column
  • xMax is a reserved word, so the map tables now have an xMaxs column


Retribution Postgresql Datadump Backup

Any issues then let me know. I will try to continue doing this until someone takes over with a better dump.
Dei
Cosmic Core Industries
#2 - 2013-01-18 18:40:21 UTC
Updated to Retribution 1.0.7.
Dei
Cosmic Core Industries
#3 - 2013-02-15 08:45:09 UTC
Updated to Retribution 1.1.
Tonto Auri
Vhero' Multipurpose Corp
#4 - 2013-02-15 09:08:38 UTC
Any reserved word can be quoted to preserve it's literal meaning.
No point in tampering with naming schemes.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Dei
Cosmic Core Industries
#5 - 2013-02-15 16:52:46 UTC
You are free to convert mssql to postgresql if you want. Good luck finding a converter that works without building one yourself though!
Caelum Dominus
Ministry of War
Amarr Empire
#6 - 2013-03-02 00:50:19 UTC
Thanks, Dei!
Kalfu Arcturus
Deep Core Mining Inc.
Caldari State
#7 - 2013-03-03 15:01:04 UTC
Could you use something more useful to unix devs than a *rar* file?
Tonto Auri
Vhero' Multipurpose Corp
#8 - 2013-03-03 15:37:05 UTC
If you can't google "rar for linux", you probably should review your "dev" title.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Kalfu Arcturus
Deep Core Mining Inc.
Caldari State
#9 - 2013-03-04 05:41:20 UTC
Tonto Auri wrote:
If you can't google "rar for linux", you probably should review your "dev" title.


And if you can't understand how to use tar and bzip2, or why it's really inappropriate to use non-free compression tools, you probably shouldn't get into the argument.
Dei
Cosmic Core Industries
#10 - 2013-03-04 07:46:34 UTC
Damn son take it easy. I've updated the link to a bzip2 archive now.
Aximag
Acme Space
#11 - 2013-04-27 01:18:58 UTC
Poking my nose in here -- is this the best place to get a Postgres data dump? If so, thanks (regardless of compression format). If not, what is a better source?
Kintsia Abre-Kai
Asimark Doclein Industries VDB
#12 - 2013-05-27 14:27:07 UTC
Dei,

Thanks for doing the leg work to get a pg version of the data.

Any chance of getting a non-binary dump? I am running pg 8.4 and the binary dump will not import as my version is too old.