PostGIS psqlostgis ERROR could not load library /usr/lib/postgresql/8.4/lib/postgis-1.5.so
Trying to install PostGIS and you can’t get past this error?
psqlostgis.sql:57: NOTICE: type “spheroid” is not yet defined
DETAIL: Creating a shell type definition.
psqlostgis.sql:57: ERROR: could not load library “/usr/lib/postgresql/8.4/lib/postgis-1.5.so”: /usr/lib/postgresql/8.4/lib/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance
psqlostgis.sql:63: ERROR: current transaction is aborted, commands ignored until end of transaction block
psqlostgis.sql:68: ERROR: current transaction is aborted, commands ignored until end of [...]
In: Ruby on Rails, Server Config · Tagged with: error, ldconfig, PostGIS, postgresql, problem
PG_Dump PG_Restore
Dump a remote postgres database and restore it into a local postgres database. This method dumps first into a local file, then restores into the database. The reason for doing it this way over piping the data straight into the database locally is that if there is an error in the import you don’t have [...]
In: Server Config, Web Development · Tagged with: database, pg_dump, pg_restore, postgresql, psql, remote server
Postgres vs MySQL
or
I have used both MySQL and Postgres and if I was starting a project right now I would probably use Postgres. I have read the wikivs MySQL vs Postgres and there is a lot in there that I understand and a lot that I don’t.
What I like about Postgres is that it uses [...]
In: Server Config · Tagged with: mysql, postgresql
Rails Migration Data Types – MySql – Postgresql – SQLite
Rails
mysql
postgresql
sqlite
:binary
blob
bytea
blob
:boolean
tinyint(1)
boolean
boolean
:date
date
date
date
:datetime
datetime
timestamp
datetime
:decimal
decimal
decimal
decimal
:float
float
float
float
:integer
int(11)
integer
integer
:string
varchar(255)
*
varchar(255)
:text
text
text
text
:time
time
time
datetime
:timestamp
datetime
timestamp
datetime
In: Uncategorized · Tagged with: migrations, mysql, postgresql, sqlite