Ubuntu :: Get Reports Regarding PostgreSQL 8.4.7 Installation?
Mar 24, 2011
I'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.
View 1 Replies
ADVERTISEMENT
May 9, 2011
I got the following task from my boss. I have to find out if there is some alternative tool for create reports from Squid except SARG. Now, we use SARG, but my boss told to me, that the main problem of SARG is, that SARG generate huge amount files, which cause problems during migration our servers. He told to me the following condition for change of current tool (SARG):
* standard package of Debian
* generate less amount of files, optimal is to save reports to the database
So I would like to ask you if you know about some tool (I can not find some by google)... and the best would be if you told to me some practical experiences.
View 1 Replies
View Related
Jun 3, 2011
I am trying to install postgres on my system. The software center doesnt have postgres listed. Am I missing something?
View 1 Replies
View Related
Jan 13, 2010
When 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.
View 8 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
May 19, 2010
I 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 ?)
View 3 Replies
View Related
Jan 7, 2011
What does one do when Update Manager squawks then reports this:installArchives() failed:
Extracting templates from packages: 71%
Extracting templates from packages: 100%
Preconfiguring packages ...
[code]....
View 9 Replies
View Related
Aug 4, 2011
I 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
View 2 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
Oct 16, 2010
Web 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.
View 2 Replies
View Related
Oct 21, 2010
It just happened for the second time some minutes ago (first time was yesterday): the update-manager window reported that 7MB needed to be download, but after clicking Install Updates 17.3MB was downloaded...It's a know issue in 10.10?
View 3 Replies
View Related
Dec 10, 2010
Although I've seen several threads with the same problem, I have not managed to solve the problem. GParted identifies my /dev/sda as unallocated disk space! The machine a Dell Inspiron M101Z laptop running Ubuntu 10.10 32 bit + W7 64 bit. I wouldn't have discovered the problem until I decided to replace my 32 bit Ubuntu with the 64 bit version, then GParted from the live cd identified my drive as Unallocated space!
I've already tried to use testdisk to write the partition table, but though it writes the table successfully and then it prompts to reboot, GParted still sees it as Unallocated. I've also tried fdisk /dev/sda then p then w to write the partition table, but again GParted screws up for some reason and sees it as Unallocated.
Code:
View 5 Replies
View Related
Apr 9, 2010
Have Karmic 9.10 ,Changed from Epson RX595 all in 1 (uses a ton of ink)Got the Lexmark Pro 805 3 in 1 because it says it supports Linux and the ink cartridge only cost $5 downloaded drivers and printer works but using Xsane Image Scanner error reports
'Lexmark_1_0_0:libsub/001/009': Device busy Using Image Scan - reports Could not send command to scanner Check the scanner status. The RX595's scanner drivers had to been manually instatlled,, in the Printer box the Lexmark shows available..
View 3 Replies
View Related
Feb 24, 2010
This 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]....
View 2 Replies
View Related
Feb 24, 2011
While 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 Related
Feb 12, 2010
I'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
View 6 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
Mar 24, 2011
I'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.
View 3 Replies
View Related
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
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
Apr 9, 2010
Problem 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 Related
Mar 10, 2011
I 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 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
Aug 13, 2011
I 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
View 1 Replies
View Related
Feb 13, 2011
I've mounted /home on its own 26 GB partition. I have 2.6 GB of files in /home/chris/. The only other thing in /home is /home/lost+found/ which appears to be empty. Nautilus reports that there is 1.7 GB free. Where is the rest of my disc?
View 4 Replies
View Related
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
View Related
