[ckan-dev] Install postgresql and ckan on diff machines

Fri Apr 19 11:38:48 UTC 2013

Hi Isabel,

As long as the server you are running CKAN on can access the DB server
it should work as if you were running the database locally.

If you are following the source install instructions [1], you have two
options to run the commands on step 3 (Setup a PostgreSQL database):

1) Log into the db server and run the commands there
2) Install postgresql-client on you ckan server (sudo apt-get install
postgresql-client) and then run the same commands but with the -h flag
pointing to your db server, eg:

createuser -h {your-db-server} -S -D -R -P ckanuser

Once you have created the database, on step 4 just be sure to specify
your remote db server in the connection string:

sqlalchemy.url = postgresql://ckanuser:pass@<dbserver>/<dbname>

I said, you will have to configure your network, ports, etc so the
ckan server can access the db server.

Hope this helps,

Adrià

[1] http://docs.ckan.org/en/ckan-1.8/install-from-source.html

On 19 April 2013 09:59, Isabel Ruiz <isaruizmellado at gmail.com> wrote:
> Hi!
>
>
> First of all, sorry: Maybe my questions are easy to solve, but I am novice
> in CKAN.
>
> I have installed Postgresql 9.1.9 on Ubuntu 12.10, and I want to create a
> CKAN  database here.
>
> I will install CKAN 1.8 on a Ubuntu 10.0.4 VM Ware machine.
>
> These are my questions:
>
> - where can I find CKAN databases script creations ?
> - can I create a CKAN database first and them install and confirgure CKAN on
> my Virutal Machine?
>
> Thanks!
>
> --
> Isabel M. Ruiz Mellado
> http://about.me/isabelruiz
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>