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
have to create a webhost on an running fedora server which runs multiple webpages + a coldfusion serveri have to add an coldfusion virtual host to these.what i would do:*crate a new user & group*enter vhosts.conf and copy an existing host and modify it for the new one.*create an new folder and copy the main files (phpstarter and webroot) *chown the files for the right useri think an apache graceful would be needet
View 1 Replies View RelatedI am trying to implement a corba program (client) to retrieve customerinformation from the server. Since the server allow to login once andperform your operations until the lifetime experies, i want the client to use already login connection to perform the retrieve function withoutlogin in to the server for every request.Suppose retrieve has three functions, logon(), perform() and logoff()Pseudo code;Quote:
1. User runs a client application
./retrieve <URI> <customerID>
2. if the client program has already login, donot login, go to 4
[code]....
I used wait4 to time a child process. but the results differ each other dramatically. why?my core source code lists as below.to the point: in linux 2.6 kernel, how to time a process with a high precision. and, only its user-time rather than the elapsed time???
static struct rusage ruse;
static pid_t u_pid;
int main(int argc, char *argv[])
{
int i;
code....
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.
I have a launcher for Quake that essentially runs a shell scripts that runs quakespasm with certain options. Is there a way to add it to AWN?
View 6 Replies View Relatedi 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"
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]....
I wrote a simple shell script called main.sh and inside it calling another shell script called rename.sh.Both are placed in a same directory.[/home/srimal/test]
$cat main.sh
Code:
#!/bin/sh
[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
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]....
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.
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]....
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 RelatedThis 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.
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 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 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 migrated joomla to my new server and noticed that the script doesn't have the permission to edit it's own configuration file and write to the cache folder. All my files are owned by root, which I guess isn't a good idea.
As what user do the PHP scripts run? Or is this system specific? I don't want to chmod all files to 777 so I'd just like to change file and folder ownerships to the user that is executing that script.
How can I know the name of the X server which runs in my system?
View 8 Replies View RelatedI'm running a Minecraft server off of a dell T110 with Ubuntu 10.1 installed, as I haven't had a chance to install Natty yet. The problem is, it's running very very slowly, past the point where I could say it's the hardware's issue.
I have an intel xeon (2.4ghz quad core) in there, with 2gb of RAM. 2gb isn't much, but the computer runs slowly even when the MC server itself is off.
I'm talking super super slow, like, the cursor doesn't even show up all the time. It disappears frequently and things take a while to render/open, a site like facebook takes about 20 seconds to completely load.
This is my first ubuntu install, so I'm kind of new to it. The only problem/solution I could think is that I may have installed the 32bit version on a 64bit processor. I don't think I did, butttt that's the only thing that occurs to me
I have debian lenny, when I run an application is slow to load (example: iceweacel open and it takes, I can hold him iceweacel work normally), I tried to change from gnome to another and the same thing, went down some services (samba, squid) and nothing. I open a terminal and it takes, I want to duplicate it and do it fast. From a terminal without X (tty1) with root run mc and moves quickly, also run as root "sudo mc" and takes to boot.Any action done with sudo it takes to run.
Can not be what it takes to make starting the applications, not the PC because it is new, and from one moment to another I began to pass this
The sudoers file is fine, in the log's nothing unusual, since other PC take long to enter samba.
I have a box that is Rec Hat Linux 5.4 with Apache server 2.2.3 . I'm told there are multiple vulnerabilities in Apache httpd, that version 2.2.16 or later is better. However, I did a package update this week and 2.2.3 is where I sit. Is there a newer version that will run or a patch for 2.2.3? Upgrading Red Hat is not an option.
View 3 Replies View RelatedI have a question regarding the user that chkconfig runs as. My chkconfig script calls some other scripts to start up a tomcat instance. But the secondary scripts use %JAVA_HOME and for some reason the user it's running under doesn't have that defined. I can call the scripts directly as the root or as another user and it works properly. But I added an echo in the script and when chkconfig calls the script it has a much smaller $PATH and no $JAVA_HOME.
View 3 Replies View RelatedI'm looking at setting up a couple automated systems: Here are a few examples:
* Internal accounting system to download and process emails
* Public web server to visit
I could put each system on its own separate box -- for example, it's generally good practice to separate anything that external users have access to (such as a webserver) from internal processes such as accounting. Now, rather than dishing out the money for two separate servers, could I get away with just installing new instances of VMWare on the same box for each system?
To give you an idea, these are not large scale computationally sensitive systems. The accounting one is simply downloading and tallying emails, and the latter is just a webserver with maybe 5 hits per day on a good day. I could definitely pick up a new box for say $50, but I wanted to know the general practice of using VMWare on the same box versus two separate boxes.
I have a cron job like this.
04 07 17 04 02 sh -x myscript
this means the file myscript should be executed when the server date comes to Apr 17 on Tuesday at 07 04 am.
But the file myscript runs on every tuesday of April month.
Php file that basically runs a few commands and echoes the output. It's for checking things like temperatures etc, space free.
You can see it in action here: [url]
I've attached the actual php file.
Two questions:
1) What more can I add to it to give me even more information?
2) I want to add hddtemp but it requires sudo to run. How can I get around this?
I have a server and i think that my server is under Ddos attack. i see that server is not having much load and only few process runs but my site opens very slow. i executed the following command on my ssh:
[Code]....
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
I installed a new squeeze serverXen Hypervisor runs the server as Dom0 anda virtual Windows XP.The server runs samba, postfix, dovecot, squid, cups and hylafax with a Frritz ISDN card (module fcpci.ko).The used memory of Dom0 rises slowly (about 5MB /h) until the system crashes.As a workaround i installed a reboot every 24 hours.htop shows normal behavior.The system is already in production, so i can't stop services to track this bug.I need some hints how to debug the running system to find out, where the memory gets lots.
View 3 Replies View Related
