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

Mon Apr 22 11:58:09 UTC 2013

OK! Finally my CKAN works!

Of course, I had to configure ports, access, etc, etc.

Thanks

On Fri, Apr 19, 2013 at 1:38 PM, Adrià Mercader <adria.mercader at okfn.org>wrote:

> 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
> >
>
> _______________________________________________
> 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
>

-- 
Isabel M. Ruiz Mellado
http://about.me/isabelruiz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130422/641a4ce8/attachment-0001.html>