Fedora :: Postgresql Won't Start In F15

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


ADVERTISEMENT

Fedora Installation :: How To Start With Postgresql

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

Ubuntu :: The PostgreSQL Server Failed To Start

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

General :: How To Start Postgresql Server Automatically When Boot?

Aug 5, 2010

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.

View 2 Replies View Related

General :: PostgreSQL Service Failed To Start Or Stop

Jan 6, 2010

I am using RHEL 5.0. I am having problem with postgresql service it is not starting, not stopping, not restarting.

View 5 Replies View Related

Fedora :: F12 : Downgrading Postgresql To 8.3 ?

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

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 View Related

Fedora Security :: Securing PHP And PostgreSQL

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

Fedora Servers :: Unable To Connect To The Postgresql

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

Fedora Servers :: Cannot Create DB On PostgreSQL Ascultaţi

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

Fedora :: PostgreSQL's PgAdmin3 Query Mode Crashes On 15 X86-64

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

Red Hat / Fedora :: Installation Of Php - Platform With Remote Postgresql Support

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

Red Hat / Fedora :: Postgresql Giving Connection Timed Out Because Of Iptables?

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

Fedora :: Schedule A Process To Start At A Specific Time (not On Start Up)?

Jan 19, 2010

I'm trying to find how to schedule a process to start at a specific time (not on start up). How would I schedule a process/application to start at a specific time (if it matters, it will be a background process). For instance, have process abc start every weekday at 5am. I've done this for windows many times though have only been using linux regularly for a few months and haven't figured out the best way of doing this.

So far the best solution I have is to create a program that will start on boot and have it check the time and sleep until the required time and then start the required process(es) at the required time(s). But this seems more of a hack since I'd expect there to be a proper way of doing this.

View 4 Replies View Related

Red Hat / Fedora :: Start SCRIPT Command At START Of TERMINAL?

Feb 15, 2009

I want to monitor my work on the terminal.I know we can use script command.But every time when I start the terminal, I have to type script to start it.I want to automate it. So where should I include this command so that it will start as soon as I start the terminal ?

MY WORK TILL NOW: I have put this "script" command in the .profile.The when I start the terminal, it became an INFINITE LOOP.I am able to "echo".Thats coming only once.....but if I write a "script" command then it is becoming an INFINITE LOOP.

View 1 Replies View Related

Ubuntu :: Can't Remove Postgresql?

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

Ubuntu Installation :: Getting The Postgresql On 11.04?

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

Programming :: Postgresql Put '' In Column?

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

Red Hat :: Can't Connect With Postgresql Using PHP On Redhat5

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

Fedora :: Auto Start A Program On Start Up?

Oct 9, 2009

I just installed TuxGuitar - very cool - and to get the sound to work I had to install Timidity++ as well. Before I start TuxGuitar I have to execute:timidity -iA -Osin a terminal window first, which is kind of a pain to do every time I run TuxGuitar.How do I get this line to execute on startup such that timidity is running when I start up? I tried adding that line to rc.local

View 13 Replies View Related

Ubuntu :: Add Database To PostgreSQL Daemon

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

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 View Related

Debian :: Cannot Get PostgreSQL Installed On Lenny?

Jan 10, 2010

I 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]...

View 1 Replies View Related

General :: Sharing Postgresql Database

Oct 1, 2010

Am 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?

View 1 Replies View Related

Security :: Securing My Postgresql Database ?

Jan 5, 2010

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.

View 12 Replies View Related

Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

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"

View 1 Replies View Related

Server :: Postgresql Runs In Multiple Pid?

Jul 19, 2010

when 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

Server :: Switch The MySQL To PostgreSQL?

Apr 26, 2011

We've been using a Wiki server at the office for years. It was originally configured to use MySQL and finally after 8+ years we're
moving the Wiki to a new platform of hardware. My question is the Wiki software (MediaWiki) is the only thing still tied to and using MySQL which we want to decommission but we've been using it for years so I'm worried we will lose the data. I've done some Google'ing to find out how can I change the MySQL database dump and successfully export it into my new PostgreSQL database however I don't know how practical or recommended this process is. I found sites like the following:

[URL]

I don't mean the exact link above but just in general taking a database from MySQL and successfully migrating it for PostgreSQL use?From what I can see in the MySQL database, there appears to be 43 tables with lots of column data and who knows what else:

Code:

mysql> show tables;
+----------------------+
| Tables_in_wiki |
+----------------------+
| dp_archive |
| dp_category |
| dp_categorylinks |

[code]....

View 2 Replies View Related

Software :: Installing Postgresql 8.4 On CentOS?

Jul 29, 2010

I am having trouble installing postgresql on my CentOS virtual machine. I am trying to compile from source by following this tutorial:[URL]..Here's the output and the commands that I have used thus far:

Code:
[root@localhost postgresql-8.4.4]# ./configure
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking which template to use... linux

[Code]...

View 3 Replies View Related

Programming :: Migrate DB From COBOL To Postgresql?

Jun 27, 2011

Is there a software or procedure to migrate DB from COBOL to SQL ( or postgresql)

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved