Server :: Postgresql-8.4 Server Doesn't Listen / Fix It?
Nov 23, 2010
I'm getting some problems setting up a Postgresql-8.4 server (using Debian Lenny).
After have installed the PGSQL server, I've changed the following files as bellow code...
If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly?
For security reasons, PostgreSQL does not listen on all available IP addresses on the server machine initially. In order to access the server over the network, you need to enable listening on the address first.
For PostgreSQL servers starting with version 8.0, this is controlled using the "listen_addresses" parameter in the postgresql.conf file. Here, you can enter a list of IP addresses the server should listen on, or simply use '*' to listen on all available IP addresses. For earlier servers (Version 7.3 or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'.
You can use the postgresql.conf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file, you need to restart the server process to make the setting effective.
If you double-checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level network connectivity problems (e.g. firewall configuration). Please check this thoroughly before reporting a bug to the PostgreSQL community.
This is the same configuration that I have in other Lenny server, which works well.
View 2 Replies
ADVERTISEMENT
Dec 5, 2009
I'm running ubuntu 9.10, the box has 2 network interfaces. I've got rsyslogd running on this box also. On one of the interfaces I have a VoIP ATA which I've configured to send syslog messages to the ubuntu box, however they're not coming up in the log file (I've configured syslogd.conf to capture logs for local2.debug and local3.debug).
rsyslogd seems to be working ok for data coming through on the other interface, but not this one. I've verified the ATA is sending data by using tcpdump and have confirmed it's using local2.debug and local3.debug. It seems perhaps it might not be listening on all interfaces? rsyslog is running with the -c4 switch.
View 2 Replies
View Related
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
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
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
Nov 2, 2010
I am trying to figure out how to turn my 10.10 server into a listener only. I have it set up using snort/acidbase. It is grabbing my network traffic just fine. I want to now set up a second server to hold all the data it collects. I need to change the snort server so it only listens. I disabled ping responses, but I want to go farther than that. I want to disable responses all together. I want it to only grab the data and store it.
View 9 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
Dec 10, 2010
For some reason I am unable to view my database tables for my Wiki & I can't understand what I am doing wrong or what I'm missing. I know for sure there's table data on my 'wiki' database but for some reason I don't know how to list it.
Code:
psql (8.4.5)
Type "help" for help.
[code]....
View 1 Replies
View Related
Jul 12, 2010
we have postgresql database in our server. when i tried to install our application it throws some error like "org.postgresql.util.PSQLException: ERROR: encoding UTF8 does not match locale en_US Detail: The chosen LC_CTYPE setting requires encoding LATIN1". the locale which is set in our server is
[code]...
I don't know how to approach to solve this error.
View 1 Replies
View Related
Apr 9, 2011
I had to rename a table yesterday due to a contact / group name change in the office and sadly I'm the only person who knows how to barely interact with SQL due to my years as a Linux Administrator. Renaming the table was simple:
Code:
iamunix=# ALTER TABLE accounts RENAME TO marketing;
ALTER TABLE
[code]....
View 2 Replies
View Related
May 2, 2011
I've got a 80 MB sql_acii backup database from our previous crashed down open solaris pc. I am trying to restore it to the postgresql of Fedora 13 but this error appears:pg_restore [custom archiver] could not uncompress data: incorrect data checkpg_restore*** aborted because of errorProcess retured exit code 1
View 1 Replies
View Related
Dec 30, 2010
I wish to use the VNC server built in to the Ubuntu to easily access it from other computers on my local network. I need to skew the VNC Server port off of the normal 5900 to something else because I am using VNC to access several computers (sometimes simultaneously) so each VNC server needs to be set with a different port #. At this point it is all local subnet connections with no incoming internet access and I am not worried about security.
View 2 Replies
View Related
Oct 23, 2010
This is my second day trying to learn opensuse. My lack of terminology makes it very hard to google for the answers. I need to do this:
opensuse:~ # yast2 install postgresql-server apache2 perl texlive perl-DBD-Pg libapr-util1-dbd-pgsql
I know about yast, however this looks like something that needs to ran from terminal.
View 9 Replies
View Related
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
Sep 2, 2010
my 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 Related
Apr 15, 2010
Client unable to listen to NIS domain server.I have configured an NIS server, which is working fine.I then configured an NIS client to share some like passwd, shadow, etc.By default the client was trying to communicate to the NIS server using the broadcast method..However if I restart the client computer, it fails to communicate or Listen to the domain server. Once I login to the pc, I then check the /etc/yp.conf file and it switched back to the broadcast method.Is there any way that I can make this entry: domain naman.com server station51.naman.com permanent so that even after the reboot it should communicate using the client-server connection rather than the broadcast connection.
View 8 Replies
View Related
Apr 6, 2010
How can I set my server to listen at a different port for http access. I would like to use port 8080 (to circumnavigate isp blocks). Also can I do the same thing for sftp connections?
View 3 Replies
View Related
Aug 26, 2010
Trying 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]....
View 1 Replies
View Related
Mar 1, 2010
I was just wondering what I have to edit in order to get Maia Mailguard to listen on port 443 instead of port 80
right now I am logging on with [URL] but I would like to connect to [URL]
View 1 Replies
View Related
Jun 28, 2009
Sometimes during bootup I get the following error:Starting Dovecot Imap: Fatal: listen(995) failed: Address already in useI tried to figure out what I could with the command lsof -i :995 and this was my output:COMMAND PID USER FD TYPE DEVICE SIZE NODE NAMErpc.mount 2936 root 7u IPv4 9201 TCP *:pop3s (LISTEN)When the system boots without the dovecot error the output of losof -i :995 is as follows:
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
dovecot 3079 root 8u IPv6 9419 TCP *:pop3s (LISTEN)
pop3-logi 3157 dovecot 1u IPv6 9419 TCP *:pop3s (LISTEN)
[code]....
View 2 Replies
View Related
Jun 22, 2010
Is it possible to somehow setup an ssh server that doesn't require a username,password or cert to login?I wish to provide shell access to a console program, which will prompt for a username and password.Encryption is essential though, and users must not be able to snoop in on each other
View 9 Replies
View Related
Jun 1, 2009
I have just configured CentOS server my new office. This is the first time I am using CentOS.
Whenever I am trying to change the webroot of the httpd server, it usually say "directory doesn't exist". whereas which can't be the case as it is home directory of the user.
To achieve this, what Do I need to do?
The second issue, I am facing that whenever I am adding new directories to public_html folder, it is not accessible. as the error page 404 is shown. I have changed the permissions to 0705 and ownership is also transferred to other user. What else is required to make new directories accessible by the web?
View 2 Replies
View Related
Oct 23, 2010
I'm trying hard to run an openvpn server on a openvz VPS, the problem is packets sent from openvpn server process, doesnt reach the client, so connection is never stablished (I run tcpdump on server and wireshark on client to carefully investigate whats wrong), the first guess is that a kind of firewall is blocking traffic (I tried connecting to server through different ISP's but it's possible the national network provider applied some filtering but it cant be on IP,src port or dst port as I'd tried different configuration.
what about deep packet inspection technics, is it possible to block my traffic?) but at exactly the same time I can transmit UDP packets using netcat from server to the guest. there is no firewall enabled in between, I had tried, tcp and udp, tried both open vpn and openvpnAS and tried any thing one can imagine! the VPN is configured as a routed (TUN) type on debian
View 9 Replies
View Related
Nov 3, 2010
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
View 6 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
May 21, 2011
Server Apache doesn't work.Note the LOG line,you cannot modify or delete "logs/"
View 1 Replies
View Related
Jun 17, 2009
I was studying for RHCE exam,and the only problem I cant query these records from the same server Every time I dig myself it digs the ICANA example website But from anther computer it works fine
[Code]...
View 1 Replies
View Related
Feb 22, 2011
when I reboot the server with centos 5.5 the SMB deamon doesn't start?
View 2 Replies
View Related
Apr 2, 2010
I have installed a linux server in my office to run 16 machines. Its main use will be a internal mail server but will be also running websites.
I have installed Ubuntu 9.10 server x64 and have got apache running.
I am looking for the simplest more robust solution for smtp, pop3 and imap. I have only ever used qmail before and found it a pain to configure and its getting old so I though I should probably try something new. I have not much experience with running pop3 or imap on linux so would love a suggestion on that.
View 4 Replies
View Related
Aug 28, 2009
Is there something that blocks cron from running a shutdown command? I'm doing a daily bounce to break an attack (I have thread about that in security forum), but I always end up doing it manually. The cron log shows it being fired off at the right time...but the server never bounces. I thought maybe I just missed it, but there is nothing in messages that shows the server restarting (unlike when i do it manually, you see the start-up logging).
View 2 Replies
View Related