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 RepliesAm 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?
I 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.
i 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"
I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View RelatedI need a shell script to back up and restore a postgresql database.
View 1 Replies View Relatedmy database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies View Relatedi want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.
View 2 Replies View RelatedTrying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
i created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"
View 1 Replies View Relatedam using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedI am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedI recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies View RelatedThis 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]....
I am trying to install postgres on my system. The software center doesnt have postgres listed. Am I missing something?
View 1 Replies View RelatedI'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.
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
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
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 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'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.
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.
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]....
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 RelatedI 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 RelatedWhen 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.
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 RelatedI 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 RelatedI 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 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