Fedora Servers :: Downgrading PostgreSQL To 8.2.x?
Feb 1, 2009
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.
View 1 Replies
ADVERTISEMENT
Nov 24, 2009
I upgraded my server machine to F12 without realising that postgresql gets upgraded to 8.4, and without realising that 8.4 can't work with 8.3 databases.
Is there a way to install postgresql 8.3 on F12, preferably from Fedora repositories?
Alternatively, is there a way to migrate an 8.3 database to 8.4? I know that the recommended approach is to dump and restore the DB, but now that I have upgraded to F12, the pg_dump command doesn't work anymore.
There is also this open-source tool called pg_migrator but I couldn't find a package for it and it requires a complicated compilation and installation procedure.
The simplest solution seems to me to remove pg 8.4 and install 8.3 on Fedora 12.
View 5 Replies
View Related
Feb 14, 2010
I need to downgrade the PHP on my Fedora 12 machine from 5.3.1 to 5.2...how do I do this?
ran 'yum downgrade php php-common php-cli' but can't get lower than 5.3.0.
View 11 Replies
View Related
Jun 21, 2009
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"?
View 1 Replies
View Related
Feb 6, 2011
I have tried to create a Postgresql DB from Konsole, but it could not. I received the following messages:
root@fedora-system ~]# chkconfig postgresql on
[root@fedora-system ~]# /etc/init.d/postgresql initdb
Initializing database: [ OK ]
[code]....
View 4 Replies
View Related
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.
View 1 Replies
View Related
Dec 9, 2010
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.
View 1 Replies
View Related
Jan 16, 2010
I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies
View Related
Feb 11, 2010
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?
View 3 Replies
View Related
May 5, 2010
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.
View 2 Replies
View Related
May 12, 2010
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.
View 4 Replies
View Related
Jan 11, 2010
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".
View 3 Replies
View Related
Jan 9, 2010
I have a problem configuring my PostGreSQL server for internal network access.
I want to be able to access my postgre server from 192.168.1.10
It works when I set listen_address to *, but if I input 192.168.1.10, or any other IP address, I always get:
Quote:
WARNING: could not create listen socket for "192.168.1.10"
FATAL: could not create any TCP/IP sockets
postgresql.conf section
[Code]....
View 6 Replies
View Related
Nov 30, 2010
Is it possible to downgrade to php 5.2 in Fedora 14?
View 2 Replies
View Related
Apr 15, 2009
I'm attempting the lovely task of uninstalling Apache 2.2 and installing Apache 2.0 on CentOS 5. This is because of my original task of installing RSA web agent which only works with Apache 2.0. I also am not allowed to just install CentOS 4. I uninstalled Apache 2.2. Attempted to install Apache 2.0 (with rpm) and got multiple dependency errors. I installed the dependencies (and sometimes their dependencies including a little dance around some circular dependencies). Then I installed Apache 2.0 with no errors. However Apache failed to start.
Here is the error:
httpd: symbol lookup error: /usr/lib/libaprutil-0.so.0: undefined symbol: gdbm_errno.
Please don't tell me it "seems like you're missing your gdbm libraries." I'm not. I'm assuming I'm having a version incompatibility issue between gdbm and libaprutil. I just don't know what version of which I need to make Apache 2.0 happy. I tried uninstalling gdbm and installing an older version but I still have the same problem. Another option is to uninstall my openldap package (2.3.13-2) which I just installed and install an older version of that but again don't know which version is right.
View 4 Replies
View Related
May 13, 2010
I want to install OpenERP software which requires python 2.5 ,but my fedora 11 is having the python 2.6 installed by default, how can I downgrade the python 2.6 to 2.5 version. Also I need to know which version of yum is compatible with python 2.5 version.
View 3 Replies
View Related
May 31, 2011
I upgraded some days ago from F14 to F15, I once had postgresql-server configured and running, but now I'm getting errors when starting the service and I can't understand where the issue is.
Here some infos
Code:
# /etc/init.d/postgresql start
Starting postgresql (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
Code:
# systemctl --failed
UNIT LOAD ACTIVE SUB JOB DESCRIPTION
[Code]....
View 8 Replies
View Related
Feb 1, 2010
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
View 2 Replies
View Related
Nov 19, 2009
I'm still new to PHP and SQL, but all the tutorials I've found connect to the database like this:
PHP Code:
Right now I'm just doing local network tests before exposing everything to the Internet.
Wouldn't leaving the password in there as plain text be a huge security issue? I tried downloading the php file off the server, and it just comes down blank. So does PHP already have a security feature that doesn't allow anyone to just nab PHP files off the server?
And for Postgre, I have pg_hba.conf set up to "trust" it's own IP address:
Code:
Would I need to use something like Kerberos, PAM, or ident authentication? Right now the only plan is to use it as login system for a website. The clients themselves won't be accessing the DB itself, because all the DB access will be through PHP.
View 4 Replies
View Related
Jun 30, 2010
I want to know how to start with postgresql
os using : fedora 10
installed postgresql with the DVD rom , by clicking the check box while installing fedora
i tried postmaster , initrd , psql commands.... (command not found error coming)
i created a local user ...........]#adduser postgresql password : 123456
for working with postgre.
as one of my friend told i installed phpPgAdmin also ...........]# yum install phpPgAdmin
now i just want to work with the postgresql....!!!
and i need full steps as i am a beginner...
View 2 Replies
View Related
Aug 11, 2011
this is my first post right here. I'm running on my first Fedora full experience, then I'm not so experienced about the specific details of the distro. Coming from Ubuntu (and certainly sad about Unity bugs), I wanted to know other distros, so I've adopted Fedora as my main OS. I often had some bugs and try to resolve them by myself but, this time, I've no idea about what can I do. So, there it goes:
Recently I've been trying to set up my PostgreSQL server for development purposes. Then I went to EnterpriseDB website and downloaded the x86-64 GUI install bundle, as I always did in Ubuntu (I never had this bug with Ubuntu). After the download, I went on with the installation, doing these steps:
Code:
sudo chmod +x postgresql-9.0.4-1-linux-x64.bin
sudo ./postgresql-9.0.4-1-linux-x64.bin
I run the installation with no problem, doing it alright, then I finish the installation and open pgAdmin3, for set up my databases. I log onto my server, put my password for postgres user and create a new server. It's all OK, so when I go to Query Mode tool (Ctrl + E), it crashes along with the pgAdmin.I decided to run the pgadmin script on terminal, looking for more details, then:
Code:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3: /opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available (required by /usr/lib64/libSM.so.6)
/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh: line 3: 4890 Segmentation fault (core dumped) LD_LIBRARY_PATH=/opt/PostgreSQL/9.0/pgAdmin3/lib:/opt/PostgreSQL/9.0/lib:$LD_LIBRARY_PATH G_SLICE=always-malloc /opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3
View 1 Replies
View Related
Oct 18, 2010
I have two machines. One is for web server and the other is for database server.I need to install php in the web server and postgresql in the database server. I installed postgresql. But could not install php as it needs postgresql library during configuration steps.
View 1 Replies
View Related
Jul 14, 2011
In our development box we are configured postgresql to work with Jboss. The thing is we have firewall iptables in our linux box. when the iptables is stopped we can connect the postgres db locally using -h option, also we can connect thru a weblink we have created using Jboss. But when the iptables is started we can't connect the db locally using the -h option and the web is giving the below error. Caused by:
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openC
[code]....
View 1 Replies
View Related
Feb 11, 2010
I need to work on CUDA, nVidia's API for GPU development. The gcc version it requires is one step below what 9.10 provides, but it works on 9.04
I understand it ultimately comes down to installing the appropriate packages, changing symlinks of gcc and to point to the correct version.
So, is there an "official Ubuntu way" to do it? As in, is there some transitional or script that does it all?
(The reason I am asking this is, generally whenever I do something like this on my own, it ends up breaking something somewhere, but if there's an official way to do it, it plays well with the rest of the system.)
View 3 Replies
View Related
Apr 7, 2011
I've messed up and by accident upgraded to php version 5.3 which does not work with Zend Loader/Optimiser.
How can I downgrade to version 5.2 without removing all the dependencies as I have pleask installed?
View 1 Replies
View Related
Jul 22, 2011
I need to install PHP 5.2 to run a script which didn't run correctly with PHP 5.3. Thus I would like to install PHP version from "lenny" packages (and not from "squeeze" packages).
I've found the following proceeding: [URL]
but I would like to use Debian packages instead Ubuntu packages.
View 2 Replies
View Related
May 5, 2010
Together with upgrading Ubuntu to 10.04 last week PHP was upgraded from 5.2. to 5.3. which contains a lot of changes... Now, some old code ain't working. How can I downgrade 5.3. to 5.2.?
View 1 Replies
View Related
Jan 2, 2011
Would there be any possible problem with installing Ubuntu 10.04 over 10.10 on a manually partitioned PC?
I am using Ubuntu 10.10 and am considering going back to Lucid. I have 2 partitions ~ home and root. I presume there would be no problems with installing 10.04 over the 10.10 root partition? Will configuration files created by 10.10 in my home folder be usable by Ubuntu 10.04?
View 6 Replies
View Related
Jun 28, 2011
I did an apt-get upgrade half an hour ago, resulting in an upgrade from firefox 4 to 5, and in that time I've already run into multiple serious problems with the new version. Is there any way to downgrade?
View 9 Replies
View Related
Feb 22, 2010
I updated to firefox 3.6 from the repository, it works bad, so I come back to 3.5 from the repository, now firefox doesn't start anymore.
Try with click not work
Try by console with
firefox not work
/usr/bin/firefox not work
/usr/lib64/firefox/firefox not work
Also try with -p and -safe-mode not work
Permission of that files are rwxr-xr-x group=root user=root
If I launch it by superuser it works
linux-dvkc:/home/pla/Documenti # firefox
kmozillahelper(19259): Session bus not found
KCrash: Application 'kmozillahelper' crashing...
Warning: connect() failed: : No such file or directory
KCrash cannot reach kdeinit, launching directly.
drkonqi(19265): Session bus not found
*** nss-shared-helper: Shared database disabled (set NSS_USE_SHARED_DB to enable).
linux-dvkc:/home/pla/Documenti #
View 3 Replies
View Related
