Ubuntu Servers :: Postgresql-8.4 Won't Boot At Startup On 9.10?
Apr 1, 2010
I have just moved to rackspacecloud and created a Ubuntu 9.10 server. Moved everything over all fine (7-10 wordpress sites). Now I have a couple rails apps that need to move over and run on postgresql 8.4.
I installed postgresql via sudo apt-get as per usual. Usually at this point the postgresql server starts up and I can forget about it. But no luck. I booted it by running /etc/init.d/postgresql-8.4 start. When I run that command it boots fine, I can connect via psql no trouble.
I rebooted the machine to see what happened. After boot, apache and mysql started just fine, wp sites came up nicely no trouble. postgresql wouldn't start up.
I have tried installing from source, I have tried using different /etc/init.d/postgresql-8.4 scripts. I have no idea what to do.
I have downgraded to upstart to 0.6.3-10. I have apt-get updated, upgraded. I have Googled. I have pushed and pulled.
Usually with any linux issue in the past I have been able to find a solution on the net or work it out myself. This one stumps me to no end.
The other irritating part is that while I wait to work out this issue I am still paying for my old server running my Rails apps.
I am trying to get SQL-Ledger installed and running on my computer, which needs PostgreSQL installed to run.Currently, I am having trouble with it starting at boot-up. How can I access the appropriate log files in order to figure out what's wrong?
Also, I need to know what httpd is, and who the owner and groups using that might be on my system.
I have a server with a postgres database, apache and a custom java application.
I am trying to run rsnapshot to backup /home /etc and /var folders.
But I am running into issues with rsnapshot and permissions. More specifically these kind of errors,
Code:
I look at the permissions on these files with ls -la, I get
Code:
The owner of the files is root and postgres users. I am using passwordless login to connect to server as user XYZ. XYZ has root access to the server and to the database.
These files are all over the place. Some in /etc and some in /var/lib for instance. How can I best copy these remaining files.
I've sucessfully installed Fedora 11 into a SunVirtualBox machine, but I would like to elimate from the boot sequence the GUI Startup. If I need it I could invoke the GUI from the command line. How I coud get this?
I have Apache 2.2.12, Gallery2, PostgreSQL 8.4, and XCache (PHP cache) humming along on a Ubuntu 9.10 (Karmic Koala) server. Can someone recommend GUI postgreSQL admin tool for managing the database other than pgAdmin?
I was previously running postgresql 8.3, but upgrading to Ubuntu 10.04, has installed postgresql 8.4 and I'm now unable to start 8.3. I don't mind using 8.4, but I need to recover the data from my 8.3 installation, But I'm not sure how to do this as I can't start the 8.3 server, and 8.4 can't read my old data directory.
Is there any simpler method to downgrading to PostgreSQL 8.2.x? I am installing an application that requires it. I have removed postgresql 8.3 and tried to install some older fedora packages, but it did not go well.
My next step was to compile from scratch. However, I'm not real experienced with make/compiling and am fond of the organizational structure of RPMs.
The other option I could pursue is keeping 8.3 and installing an isolated 8.2 server for exclusive use by this app.
Is there anyone out there running Menalto's Gallery2 on Ubuntu 9.10? I'm trying to install Menalto Gallery2 2.3.1 on Ubuntu 9.10 + php 5.3.1 + apache 2.2.12 + postgresql
php5 is configured and running correctly. I verified the config using gallery2 ghcc (gallery host compatibility checker) and running a "test.php" (<?php phpinfo();?>). a2enmod php5 is enabled.
Whenever I try to run the install script in the http://mysite.com/gallery2/install folder, the "index.php" file is not executing it just downloads the "index.php".
I have recently Installed Fedora 11. I have installed postgres like yum install postgresql but I wonder there is no user created for postgres when I tried su postgres system says, no identity for user postgres. even when I tried to connect postgres server using psql then it says
Code:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I'm wondering how I start it automatically when I boot up the ubuntu 10.04? especially, when I created the user "postgres", I set a password to it. every time I issued "su - postgres" command, I need to give it a password.
I'm trying to install postgresql 8.3 on Ubuntu 8.04 LTS server and I'm running into problems starting it. Commands I've done # apt-get install postgresql postgresql-common Things I've tried Starting it manually
# /etc/init.d/postgrsql-8.3 start
Nothing appears in my /var/run/postgresql When I try and start psql as the postgres user I get the following error psql: 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"? I've been following the docs at: https://help.ubuntu.com/community/PostgreSQL
I have a Computer, It came with Windows 7 64bit on it. I installed Ubuntu through WUBI. I used the Windows Disk Management program to resize my HDD. I shrunk the main drive and created a 20 gig free space. I installed WindowsXP on this 20g space. I had to change from AHCI to ATA. I started my new XP installation. As I should have expected my the screen that let me pick between Windows 7 and Ubuntu was gone, and it just said XP. Well thats cool. I get in XP use bcdeasy and use the install Win7 to mbr. So I restarted. Great I now I have Ubuntu and Win7... but no XP. So i think, okay, ill boot into Ubuntu, use the update grub command and XP will be there, so i do it and restart. No XP, So i try to boot into Win7 and see if i can do something in there.. No luck it says it can't boot and takes me to a startup recovery thing. Which, as Windows recovery things tend to do, doesn't find anything wrong. So I have Ubuntu now, which is great, but I do need Windows.
one of the servers is the "main guy" which has NIS and NFS. the others mount the partition and can log in whith the same "main" account.
my problem is that i need to call a startup script "settings.sh" to set some enviroment variables for the cluster to work.
this script is on the NFS folder.
i would like if possible to call this script as early as possible, even before login phase, since they are servers and can be shutdown, restarted, etc.
at the moment i need to log via ssh into every one of the 4 nodes and do "source /opt/cfc/sge/default/common/settings.sh" manually each time they reboot.
i would like to put this script somewhere so that it gets called after the NFS mount, but without the need to log into an account. is possible?
otherwise i could set the nodes to automatically login into the main account..
im a little confused on something really simple, i know. But on the past i always used .bash_rc, this time i dont want to take that solution.
I've just installed the ubuntu server system on an old PC i'm going to be using as, you guessed it, a server. Because I like (some) graphical tools while configuring I also installed ubuntu-desktop on it afterwards.
The only problem is that I want to keep ubuntu-desktop, but that I don't want to boot into the (memory consuming) graphical interface by default.Does anyone know how to do that? (set the default boot to command-prompt). Also, does anyone have tips on packages I c an safely remove to clear up space and memory? (Like: openoffice, Evolution,Rhythmbox etc. are very obvious, but maybe some more hidden services and alike? Networkmanager e.g.?)
i am succesfully installed TeamSpeak 3 server and now i want to startup it automatically without screen daemon and on every startup on linux ubuntu 9.10 i am using this command for start the TS3 server:./ts3server_linux_amd64 dbplugin=ts3db_mysqlin home/user/Desktop/ts3server_linux_amd64
I am trying to run my script at startup but it doesn't run the script as root. Do I need to add my root username and password in the script, or somewhere else?
I have a server that, due to the amount of data it's moving, tends to trash up the hard drive when I have a power outage or crash. It doesn't have a keyboard or monitor attached to it normally so it's a real pain when I have to boot it back up. I have to hook one up just to hit F to have it fix all the errors. Is there a way to have it do this automatically on boot rather then having to confirm it?
I'm having a problem with a server I just got. The first thing I did when I got it was to format the drive and install ubuntu server, but on booting up I got a black screen and my monitor (samsung syncmaster914v) displayed a bouncing notification with the text "not optimum mode recommended mode: 1280 x 1024 60hz". However at one by using a combination of plugging in the monitor after booting, and pressing random keys on the keyboard I was albe to boot into the server, and was able to access the monitor meu, which told me it was running at 640x480, and 60 hertz. having access to the console I stupidly tried changing the resolution and then rebooted, getting the same black screen.
I'm running Ubuntu 9.10 as a web/ftp/etc server. I like to work on stuff from remote locations and have set it up to be accessed it with the external IP address by my laptop.The problem is that if I'm at a remote location and tell it to restart, when it boots up it won't log me on unless I enter the password, but I can't remote access it until I'm logged in.So, is there a command or script that I can run that will tell it to restart and bypass entering a login password?I'm only looking for something to bypass it ONCE per command/script, NOT to disable my password.
Just curious if it is possible to schedule a complete system shutdown and start up?
My box with ubuntu server on it is only used as an ssh/proxy server, so I would like save on energy costs and add a layer of security by completely shutting it down during the hours I do not use it.
How can I disable the startup for ubuntu's desktop during booting the system?I would like to start it manually.I tried to remove the /etc/init.d/gdm file but no help.
I have both ubuntu and kde-desktop installed, and after trying KDM, switched back to GDM which worked fine for a while (although KDE changed my other gnome settings like usplash and cursors which took a while to change back). A day later, though, when I start up my system, the screen flickers a few times then shows me a message that an x-server is already running, so hit no to try loading it on '0' again or yes to try another number.
If I hit no, it will briefly show me the KDE login screen refresh a few times and go back to the menu. If I hit yes, it refreshes about 7 times and finally shows the gnome login screen. This process takes a long time and I'm not sure is great for my screen.
On startup - prompt asking for apache certificate password doesn't accept input. Can switch to another tty but can't restart apache due to the port already being bound (suppose I could change ports for apache config after startup but that's pretty ugly and clearly not the right way to address the problem.
I'm new to ubuntu and I wanted to setup a headless server (Asus Hummingbird, 2GB RAM, Ubuntu Server 11.04). The installation was successful but: After I tried starting my server without any connected monitor, the server did not start -> I run into a kernel panic (if I connect the monitor after a while I can see the messages on the screen, Keyboard lights flash...). What do I have to do to get the machine running without any monitor? My second problem is, that the Network is always powered down on system power down -> no WOL is possible. Is there an easy way of enabling the WOL function? I tried several things from different tutorials but nothing worked...
