IIUC you need to be running as the postgres user; i.e.: sudo su - postgres. L
On Aug 6, 2012, at 9:19 AM, Tom Huffner <thuff...@gmail.com> wrote: > That seemed to progress things, Erik...thanks! > > At least now, when I try to create a database, it recognizes it as something > exists. However, now, it doesn't recognize my username (ubuntu) as a role > that exists, throwing this error: > > createdb: could not connect to database postgres: FATAL: role "ubuntu" does > not exist > > hmmmm... > > On Mon, Aug 6, 2012 at 12:12 PM, Erik Froese <erik.fro...@gmail.com> wrote: > Tom, > > Looks like createdb can't connect to your postgres instance. > Can you try starting postgres with /etc/init.d/postgres start? > > That script probably configures the postgres daemon properly for your system. > > Erik > > On Mon, Aug 6, 2012 at 3:09 AM, Tom Huffner <thuff...@gmail.com> wrote: > > 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 > > > > _______________________________________________ > 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
