Ubuntu Installation :: Getting The Postgresql On 11.04?
Jun 3, 2011I am trying to install postgres on my system. The software center doesnt have postgres listed. Am I missing something?
View 1 Replies
ADVERTISEMENT
Ubuntu :: Get Reports Regarding PostgreSQL 8.4.7 Installation?
Mar 24, 2011I'm trying to install pg_config so I can get some simple reports regarding my PostgreSQL 8.4.7 installation.
I downloaded pg_config and its dependencies and tried to install them with the package installer, but it wouldn't go because it seems like something may be wrong with the libkrb5-3 and libkrb5support0 packages - they won't install and the package installer just zips through without reporting missing dependencies or anything. The MD5, SHA1, and SHA256 checksums all match, but they just won't install.
I downloaded all the packages from the ubuntu [security] repository.
Because my Ubuntu 10.04 (Lucid) machine is not connected to the internet, I download packages to my Windows 7 machine, transfer them across my network to a shared folder on my Ubuntu machine and double-click the package to install.
I've successfully installed postgresql-8.4, apache-2.2.14, php-5.3.2, drupal-6.16, and several other packages and all their dependencies this way without any problems before.
To make sure I wasn't having some new problem, I then tried installing libk5crypto3 - it installed fine.
I sent an email to frank@lichtenheld.de , the repository maintainer, but haven't heard back from him yet.
Ubuntu Installation :: PostgreSQL 8.3 Becomes Inaccessible With Upgrade To Karmic
Jan 13, 2010When I recently upgraded my desktop to Karmic, my postgresql 8.3 no longer starts. I've got data in 8.3 that I need, but now no way to access it. Karmic upgrades to Postgresql 8.4, but leaves 8.3. Problem is, I can't seem to start 8.3 no matter what I do (there's no error message. I even tried removing 8.4 entirely--without effect. When I try to start 8.3 (using command line or boot-up manager), there is no error message, either in system logs or in the postgresql log file. There is also no indication of an active postmaster in ps aux or anything listening to postgresql ports in nmap (for that matter, seems there's nothing listening even with 8.4 activated).
I could try to 'upgrade' my data cluster to 8.4. Never tried that before and am concerned about possibly losing data. Also, I made a load of tuning adjustments to 8.3 that I'd have to replicate with 8.4. I'd rather stay with 8.3, if possible. There are also two pieces of software, postgresql-common and postgresql-client-common, that presumably allow one to run two versions of postgresql simultaneously. Maybe this stuff is even the source of my start up problems. No idea where to learn how to use this software, and, esp., whether this would solve the 8.3 start problem.
Fedora Installation :: How To Start With Postgresql
Jun 30, 2010I 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...
Ubuntu Installation :: Upgrade From Karmic To Lucid Disables PostgreSQL-8.3?
May 19, 2010I just upgraded a Ubuntu Desktop 64bit system from Karmic (9.10) to Lucid (10.04). There were several PostgreSQL 8.3 clusters running on that machine. After the upgrade, postgresql was not able to run anymore.
The package postgresql-8.3 was marked "rc" in dpkg -l I was not able to re-install PostgreSQL 8.3 because of a mismatched dependency. There was no warning. I guess i should have read the release notes, which i didn't. There should have been a warning before it was too late to turn back and upgrade postgresql to 8.4 first. I don't see how this is supposed to work, ever.
I'd like to know if this would be considered a bug, if it is known already and how to correctly file this bug correctly if appropriate (ubuntu-bug ?)
Ubuntu Installation :: Postgresql Works From Cli - Error Call To Undefined Function
Aug 4, 2011I have weird problem with postgresql + nginx + php5 0 ubuntu 11.04. Postgresql works just fine, when I run "php test.php" from shell. I assume php runs from shell are called cgi runs? When I open page from browser [URL]... I get following error. I assume php runs from browser are called cgi runs? Fatal error: Call to undefined function pg_connect() in /var/www/mydomain/htdocs/test.php on line 7 When you print php info, only reference to postgresql is pgsql.ini and pdo_pgsql.ini files that are parsed.
[code]....
I did install postgresql by running following commands:
sudo -s
aptitude install postgresql
aptitude install php5-pgsql
Red Hat / Fedora :: Installation Of Php - Platform With Remote Postgresql Support
Oct 18, 2010I 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 RelatedSoftware :: Installation Of Php And Apache To Get Remote Access Of Postgresql
Oct 16, 2010Web Server
================ I have been successful to set up the pic-1 server.
| | This requires only one machine.
| Apache |
[code]....
But now I have two machines.One for Database server and the other is for Web server.pic-2 describes it.
Server Database Server
================ ================
| | | |
| Apache | | |
[code]....
I have installed postgresql in one machine.Apache has also been installed in the other machine. But php requires postgresql library support during configuration.I cant remotely access the postgresql from the other machine during configuration.
Ubuntu :: Can't Remove Postgresql?
Feb 24, 2010This is what I get: think its partially removed or something.
Code:
server@A-srvr:~$ sudo apt-get remove --purge postgresql
Reading package lists... Done
[code]....
Ubuntu :: Add Database To PostgreSQL Daemon
Feb 24, 2011While watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
View 2 Replies View RelatedUbuntu :: The PostgreSQL Server Failed To Start
Feb 12, 2010I'm getting this error message every time I run updates.
Quote:
dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-8.4; however:
Package postgresql-8.4 is not configured yet.
dpkg: error processing postgresql (--configure):
[code]....
The following details are provided:
E: postgresql-8.4: subprocess installed post-installation script returned error exit status 1
E: postgresql: dependency problems - leaving unconfigured
Ubuntu Servers :: Postgresql-8.4 Won't Boot At Startup On 9.10?
Apr 1, 2010I 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.
Ubuntu Servers :: Rsnapshot And Postgresql - Permission ?
Dec 9, 2010I 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.
Ubuntu :: Finding The PostgreSQL Installed Location?
Mar 24, 2011I'm using ubuntu 10.04 and PostgreSQL 8.4.7. I need to find out where PostgreSQL is located so I can run commands. I successfully installed PostgreSQL without changing any of the defaults. Matthew & Stones' Beginning Databases with PosgreSQL From Novice to Professional, as well as the PostgreSQL documentation, indicates the standard location is /usr/local/pgsql/bin/ but it's not there; it's somewhere else (ps -el | grep post confirms it IS running and psql is able to do du to display the list of users and l to display the list of databases).
But when I tried to create a new user by running /usr/local/pgsql/bin/createuser the command was not found. I tried to locate the installation by running pg_config --bindir but it said pg_config was not installed. I downloaded pg_config and its dependencies and tried to install them with the package installer, but it wouldn't go because something is wrong with the libkrb5-3 and libkrb5support0 packages - they won't install and the package installer just zips through without reporting missing dependencies or anything. The MD5, SHA1, and SHA256 checksums all match, but they just won't install. I then tried the libk5crypto3 package just to make sure something wasn't wrong on my end - it installed fine. So I searched the PostgreSQL FAQ and found out how to get the version without pg_config by doing a SELECT version(); query. here appears to be no corresponding SELECT bindir(); query. A plain ordinary file search for pgsql, postgresql, etc.
Fedora :: F12 : Downgrading Postgresql To 8.3 ?
Nov 24, 2009I 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.
Fedora :: Postgresql Won't Start In F15
May 31, 2011I 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]....
Programming :: Postgresql Put '' In Column?
Apr 9, 2010Problem is simple but I can't figure out how to solve it, I tried any possible way that I know but with no result.I'm using simple perl script with DBI and do select from one table and do update in other table with results from select, but I can't preserve my '' returned from select when doing update. I simply want my '' from first table to be '' in second but postgres makes them real new lines. I tried to escape '' with , '',"",E(I mean E'value here') in front of value that updating but they are always real new lines not '' in new table.
View 2 Replies View RelatedRed Hat :: Can't Connect With Postgresql Using PHP On Redhat5
Mar 10, 2011I cannot connect postgresql using PHP on redhat5. I am using adodb library for database manipulations. It showing the error that could not open the stream adodb/adodb.inc.php file..
View 2 Replies View RelatedUbuntu Servers :: How To Clear Postgresql Database Cache
Jan 16, 2010I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View RelatedUbuntu Servers :: PostgreSQL 8.4 GUI Admin Tool For 9.10 (Karmic)
Feb 11, 2010I 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 RelatedUbuntu Servers :: Recovering Data From Old PostgreSQL Install
May 5, 2010I 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 RelatedUbuntu Servers :: PostgreSQL Not Starting At Boot & Httpd?
May 12, 2010I 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.
Ubuntu :: Permissions Error With PostgreSQL Psql Process?
Aug 13, 2011I have installed PostgreSQL 9.0 in Ubuntu 11.04.The following is a bit long-winded and cross-relates to PostgreSQL,I ran the PostgreSQL installation thus:
Code:
sudo su
./postgresql-9.0.4-1-linux.bin[code]....
The problem, obviously, is the "Permission denied" error. What/where am I going wrong? From my directory listing I can see that the permissions for gjd_sentinel_data are drwxrwxrwx with owner/group of postgres. On that basis I can't see why there is the problem.I am wondering if it has something to do with the psql process running as, or owned by, user postgres? Or that I am running as the wrong user? Or something else beyond my experience?
---
Ubuntu 11.04 with GNOME2 classic desktop
Single user.
Dual boot with Windows XP Home
Fedora Servers :: Downgrading PostgreSQL To 8.2.x?
Feb 1, 2009Is 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.
Fedora Security :: Securing PHP And PostgreSQL
Nov 19, 2009I'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.
Debian :: Cannot Get PostgreSQL Installed On Lenny?
Jan 10, 2010I have tried many variations of the following, but always get the same error.
Quote:
# aptitude install postgresql-8.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
[Code]...
General :: Sharing Postgresql Database
Oct 1, 2010Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
Security :: Securing My Postgresql Database ?
Jan 5, 2010I run Slackware 13.0 and I have an apache server 2.2.13 with a postgresql 8.4.1 database attached to it via php 5.3.0. Both the apache server and the postgresql database are on the same machine.
I have the apache server port 80 exposed to the WAN. It is not a fqdm, it's just a simple IP address. On my index page, a user can login with a user/password that encrypts to md5 via postgresql and takes them into the database.
Here is the vulnerability. Can't a hacker just scan port 80 and find my ip address running apache. Go to my index page, see that I accept user/password for authentication into my postgresql database. Then they could setup a script to simply inject html GET requests of random users and passwords and use those values on the php page(the one where the action link is pointing to in the form tag) that contains user login/password in php to login to my postgresql database. There's nothing stopping that. It would be a simple dictionary attack.
I checked out postgresql documentation and it suggested using ldap, kerberos, or md5 and not trust. I'm using md5 already. I currently use fail2ban for proftpd and sshd and it works great. After 6 failed user/pass attempts on either of these services, the IP gets banned via iptables for 24 hours. I love it. I was wondering if I could use that. Of course postgresql port is not exposed to the WAN which is a good thing. I know that when I put in a wrong user/pass from my index page, I get sent to a default postgresql pg_connect warning page. Perhaps I can increase the verbosity of postgresql's logger, find the phrase that it spits out when there's been a bad login and create a filter using that.
I understand that the way it is currently setup, my server is pretty secure, but where there's a will there's a way. I just feel that my postgresql database is unprotected even tho the postgresql port is not exposed to the WAN. They could just bruteforce from the apache server.
Server :: Cannot Create Database In PostgreSQL
Dec 26, 2010i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
Server :: Postgresql Runs In Multiple Pid?
Jul 19, 2010when i give service postgresql status command. i get the following.ostmaster (pid xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx) is running...The issue is my postmaster service is running in multiple process ids.As a result my cpu usage becomes high.How to resolve this. my postmaster service need to be run under only one process id
View 3 Replies View Related