Thread: Setting up postgresql-8.3 on Debian
HI All
In order to test the replication setup for a client, I need to setup posgresql 8.3 on Debian 5.
I have installed Debian on 2 virtual machines and they can connect to one another and the internet just fine.
However, when I use apt-get using the install dvd or online packages to setup postgresql, I don’t succeed.
The problem I am experiencing are as follows:
· I use apt-get to install the relevant packages for postgresql-8.3
· When I list /etc/postgresql directory, it is empty.
· Listing /var/lib/postgresql-8.3 it is also empty.
· Even when changing to postgres user, I am unable to use initdb as it can not be found.
· Using psql command (command can be found) but it says that the database is not running or not allowing socket connections.
· /etc/init.d/postgresql-8.3 start also does absolutely nothing.
Have anybody experienced this before or perhaps know what I am doing wrong? Assistance would be much appreciated.
Regards
Machiel
On 27 May 2010 11:28, Machiel Richards <machielr@rdc.co.za> wrote: > HI All > > In order to test the replication setup for a client, I need > to setup posgresql 8.3 on Debian 5. > > I have installed Debian on 2 virtual machines and they can > connect to one another and the internet just fine. > > However, when I use apt-get using the install dvd or online > packages to setup postgresql, I don’t succeed. > > The problem I am experiencing are as follows: > > · I use apt-get to install the relevant packages for postgresql-8.3 Please specify which packages you are referring to. AFAIK everything should be set up by the post-install scripts that run when you install the package. > · When I list /etc/postgresql directory, it is empty. > > · Listing /var/lib/postgresql-8.3 it is also empty. That looks wrong. > · Even when changing to postgres user, I am unable to use initdb as > it can not be found. I don't think you should need to do this. > · Using psql command (command can be found) but it says that the > database is not running or not allowing socket connections. > > · /etc/init.d/postgresql-8.3 start also does absolutely nothing. > > Have anybody experienced this before or perhaps know what I am doing wrong? > Assistance would be much appreciated. -- Michael Wood <esiotrot@gmail.com>
On 2010-05-27, Machiel Richards <machielr@rdc.co.za> wrote: > This is a multipart message in MIME format. > > ------=_NextPart_000_00E9_01CAFD8F.B4401650 > Content-Type: text/plain; > charset="US-ASCII" > Content-Transfer-Encoding: 7bit > > HI All > > > > In order to test the replication setup for a client, I need > to setup posgresql 8.3 on Debian 5. Debian releases have cute names (taken from Toy Story) 5 is Lenny (I use it and I had to look it up, in the movie Lenny the walking binoculars) >> I have installed Debian on 2 virtual machines and they can > connect to one another and the internet just fine. > > > > However, when I use apt-get using the install dvd or online > packages to setup postgresql, I don't succeed. > > > > The problem I am experiencing are as follows: > > > > . I use apt-get to install the relevant packages for postgresql-8.3 apt-get install postgresql-8.3 > . When I list /etc/postgresql directory, it is empty. ??? config files should be in /etc/postgresql/8.3/main/ > . Listing /var/lib/postgresql-8.3 it is also empty. likewise /var/lib/postgresql-8.3/main/ > . Even when changing to postgres user, I am unable to use initdb as > it can not be found. mysterious... in any case the install should do the initdb for you. > . Using psql command (command can be found) but it says that the > database is not running or not allowing socket connections. > > . /etc/init.d/postgresql-8.3 start also does absolutely nothing. > Have anybody experienced this before or perhaps know what I am doing wrong? > Assistance would be much appreciated. This is amd64 or i386, not something exotic, right? what do you get from the command dpkg -l 'postgres*' (you can run that as any user)