Exciting stuff happening on Mars isn't it??
Anyways - I was able to shut down the database using the following command:
*/usr/lib/postgresql/9.1/bin/pg_ctl stop -D/usr/var/postgresql/9.1/main/*
But am having an issue creating a database within the service.
I can start a clean database server with the following commands:
*/usr/lib/postgresql/9.1/bin/pg_ctl -D \
/home/ubuntu/postgres/dbdata -l \
/home/ubuntu/postgres/db_logfile start*
But can't seem to create a database. What is recommended is the following:
postgresdir/bin/createdb sakaioae
I found two createdb files, and tried both commands (logged in as both the
sakai user and as postgres) to try and create a database within the
service, but get the same error with each command (listed after):
*
/usr/lib/postgresql/9.1/bin/createdb sakaioae
/usr/bin/createdb sakaioae*
Error I received with both:
*createdb: could not connect to database postgres: could not connect to
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?*
Any ideas?
Thanks,
Tom
On Fri, Aug 3, 2012 at 2:57 PM, Zach A. Thomas <zach.tho...@gmail.com>wrote:
> Hi, Tom. /Library is a Mac OS X path.
>
> We're using PostgreSQL on one of our ubuntu servers, and while it's a
> somewhat older version, this is the command we use:
> /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c
> config_file=/etc/postgresql/8.4/main/postgresql.conf
>
> So you might have luck looking in /usr/lib, /var/lib, and /etc for what
> you need to run your db.
>
> regards,
> Zach
>
> On Aug 3, 2012, at 1:12 PM, Tom Huffner <thuff...@gmail.com> wrote:
>
> Hey Max, thanks for the web site! I am actually doing our install on 1.3
> and I can't seem to get things straight.
>
> Is the directory structure of 1.2 vs. 1.3 the same or any different?? I
> switched to the postgres user, tried to run the following command as listed
> on the web site:
>
> */Library/PostgreSQL/9.1/bin/pg_ctl stop -D/Library/PostgreSQL/9.1/data/*
>
> But do not see a Library folder, even after searching for one. Is this a
> wildcard library folder or (again), am I missing something?
>
> Thanks!
> Tom
>
> On Thu, Aug 2, 2012 at 1:23 PM, Max Whitney <m...@nyu.edu> wrote:
>
>> Hi Tom:
>>
>> I did Postgres install notes for OAE version 1.2 back in June. They are
>> not current with 1.4, but might provide some insight. The notes are posted
>> on the OAE community instance, which has a lot of useful information.
>>
>>
>> https://oae-community.sakaiproject.org/content#p=lbmK1eqsKub/Sakai%20OAE%201.2%20Postgres%20Installation
>>
>> You might also consider the O'Reilly book which provides an overview of
>> installation on 1.2: http://shop.oreilly.com/product/0636920023241.do
>>
>> Max Whitney
>>
>>
>> On Aug 1, 2012, at 1:21 AM, Tom Huffner wrote:
>>
>> Hey everyone...my name is Tom Huffner and I am working with Dr. Wang at
>> the University of Delaware to get an instance of OAE up and running where
>> we can make our own changes.
>>
>> I'm at the point of beginning database integration, and we would like to
>> use PostgreSQL in our Ubuntu environment.
>>
>> I followed the simple instructions on how to install it from the web
>> site: http://www.postgresql.org/download/linux/ubuntu/ and simply ran
>> this command: *sudo apt-get install postgresql-9.1*
>>
>> My question is: is this the only command I should run to install it??
>> There are 5 other packages that I can install (as listed in the above web
>> site)...are all/any of those necessary for OAE/PostgreSQL integration? In
>> my OAE Deployment and Management instructions, it then tells me to work in
>> the bin directory of Postgres, but I can't seem to find it in /etc/postgres
>> or /etc/postgres-common Am I missing something??
>>
>> Thanks so much!
>> Tom
>> _______________________________________________
>> oae-dev mailing list
>> oae-dev@collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/oae-dev
>>
>>
>>
> _______________________________________________
> oae-dev mailing list
> oae-dev@collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/oae-dev
>
>
>
_______________________________________________
oae-dev mailing list
oae-dev@collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/oae-dev
