Running Postgres

Feb 20, 2008

I have installed postgres over my cpanel account but I am unable to find php_pgsql.so file

I am running Centos 4 Apache 1.3 PHP 4.3 Postgres 7.3

View 4 Replies


ADVERTISEMENT

Postgres Install

Feb 19, 2008

I have a server running Cpanel and I have added postgres through /scripts/installpostgres, also I have set it over WHM and can access phppgadmin but I got this error when connecting throug a script

Fatal error: Call to undefined function: pg_connect() in /home/rer1223/public_html/process/Connection.php on line 4

I checked and postgres is not listed in phpinfo output.

View 5 Replies View Related

Cannot Add Postgres Database

Jul 9, 2007

PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added.

root@server [~]# rpm -qa | grep postgre
postgresql-devel-8.1.4-3PGDG
postgresql-contrib-8.1.4-3PGDG
postgresql-8.1.4-3PGDG
postgresql-server-8.1.4-3PGDG
postgresql-libs-8.1.4-3PGDG
postgresql-python-8.1.4-3PGDG

I've already compiled apache after postgres was upgraded months ago.

I'm using cpanel 10x

View 1 Replies View Related

Restoring 1.5GB SQL Dump (Postgres)

Jan 23, 2007

This seemed like the most appropriate place so I decided to post here.

SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4

The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.

Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.

I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:

Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.

I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.

Is there a way I could perhaps split up my db dump and then import them into the db one by one?

View 2 Replies View Related

Cron As Postgres User Not Working

Jun 14, 2007

I was hoping someone could shed some light on a cron related issue I'm having.

I've been using linux for a while...but never really used crons.

My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't.

I opened my cron in vim via:

Code:
postgres@myhost:~$ crontab -e
And here's the cron:

Code:
* * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz

Also:

Code:
postgres@myhost:~$ ls -lah /var/www/test/postgres/
total 8.0K
drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 .
drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 ..

Running the backup command via CLI works fine.

View 5 Replies View Related

Postgres: Restoring A Filesystem Backup

Feb 19, 2007

i had to do a file system back up because of the size of my database.

i shutdown postmaster and tar'd the files.

i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster.

i then su'd from root to postgres user:

Code:
[postgres@austin1 pgsql]$ psql service_2_3
psql: FATAL: database "service_2_3" does not exist
DETAIL: The database subdirectory "base/16385" is missing.

the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available.

my data directory is /var/pgsql/data.

Code:
[postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385
but that yielded nothing.

have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me.

how i can resolve this issue if you have the time.

View 6 Replies View Related

IDENT Authentication Failed For Postgres. Pg_hba.conf

Feb 15, 2007

I just reloaded the OS on our production server and I'm having issues configuring postgres.

the user postgres exists in the system (i.e. 'su postgres' switches me to that user)
i attempted to connect to my database 'service_2_3' via CLI:

Code:
$ su postgres
$ psql service_2_3
and i recieved the following error:

Code:
psql: FATAL: IDENT authentication failed for user "postgres@service_2_3"
the database is installed on the machine on which i was attempting to connect to it with.

therefore, i edited my pg_hba.conf so that it looks like this:

Code:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
host all all 0.0.0.0 0.0.0.0 password

and reloaded with (as user postgres):

Code:
bash-3.00$ pg_ctl reload -D /var/lib/pgsql/data -l /var/lib/pgsql/data/temp.log

but i still get the same error. am i editing the wrong file, perhaps?

how would i know which is the correct pg_hba.conf file?

locate pg_hba.conf seems to give me a few results.

View 3 Replies View Related

Running XEN

Oct 5, 2009

I want to purchase a dedicated server onwhich I can set up XEN and make few virtual machines.

how to manage backups - get a sepeare machine and configure it as a NAS, use R1Soft backups etc.

View 5 Replies View Related

Running Out Of My 512 MB Of RAM With VPS

Apr 14, 2008

I recently signed up for a VPS server with 512 MB of RAM. I will be hosting two sites on this VPS server. One is not online yet and I just have a Coming soon page up. The other is a Wordpress blog that is running. I don't have any users yet. But my VPS server is currently using ~410 or my 512 MB. This is with essentially nothing running yet. Does anyone else run their websites with only 512 MB or do I need to upgrade to at least 1 GB? I also checked out which processes are taking up the most
(% wise):

5.6 1 /usr/bin/spamd
5.4 2 spamd
3.8 1 /usr/bin/python
3.4 1 /usr/sbin/mysqld
1.7 1 /usr/local/apache/bin/httpd
1.7 1 cpsrvd
1.7 1 cpdavd
1.6 1 /usr/sbin/restorecond

I know I can't disable apache but what about the others? Spam Assasin is disabled in the WHM but the process restarts even after I kill it. Is Python necessary? I am using php apps..

View 12 Replies View Related

Running Rtg

Nov 13, 2007

after compiling rtg, I run this
/usr/local/rtg/bin/rtgpoll -v -t targets.cfg

and see the data is collected already. However, I cannot keep ssh window all the times. So, how to run rtg automatically as daemon?

View 3 Replies View Related

Can't Get PHP 5 Running With IIS

Jul 20, 2007

let alone with mysql. Have tried to install those both and have tried endless variations of php settings adn moving php.ini around and checked PATH in IIS adn teh extension .php is enabled.

Question:
Should php.ini be copied to Windows or Windows/system32 directory?

I have a test.php file in my virtual directory. I did have it working at one time but then I installed the extensions so I could have teh mysql extension and it hasn't worked since.

I am just a newbie trying to create a testing environment so I can teach myself PHP. I have endless books, have tried the Yanks method but I am not sure it applies to PHP5.

I have PHP at c:/program files/php/ is this a problem? Shoud it just be directly in the c directory? Does that matter?

View 0 Replies View Related

Running Csf

Jun 17, 2007

I installed csf as my server's firewall with using cpanel besides, I've customized configuration file and everything seems to be right but when i use csf -s it results this error :

iptables: No chain/target/match by that name
LOG tcp opt -- in * out * 0.0.0.0/0 -> 0.0.0.0/0 limit: avg 30/min burst 5 LOG flags 0 level 4 prefix `Firewall: *TCP_IN Blocked* '
Flushing chain `INPUT'
Flushing chain `FORWARD'
Flushing chain `OUTPUT'
Flushing chain `LOGDROPIN'
Flushing chain `LOGDROPOUT'
Flushing chain `acctboth'
Deleting chain `LOGDROPIN'
Deleting chain `LOGDROPOUT'
Deleting chain `acctboth'
Error: iptables command [/sbin/iptables -v -A LOGDROPIN -p tcp -m limit --limit 30/m --limit-burst 5 -j LOG --log-prefix 'Firewall: *TCP_IN Blocked* '] failed, at line 196

View 14 Replies View Related

Running A Vps Within A Vps

Apr 27, 2007

i'm thinking of installing virtualization software on a linux vps machine.

reason... windows vps vost so much and linux are much cheaper.
so within my cheap linux vps, i can install virtual windows using my pre-purchased win2000 license key.

has anyone tried this or is it completely not possible. also what linux-host virtualization software would you recommend?

note my linux vps already has kde with vnc running so i have a graphical interface to my linux vps at home.

View 14 Replies View Related

Running A JVM On A VPS

Aug 13, 2007

I'm aware of the limitations of using Sun's JVM on a VPS. Are there any good JVMs I can run besides Sun's?

View 14 Replies View Related

Running Out Of Bandwidth

Jan 19, 2008

I have a question that's been bugging me for a few months now (which has gotten worse as traffic increases). I run a site that gets some decent traffic (about 9-10M pageviews per month), and is mostly made up of HTML pages with a lot of images (some pages have about 200k of images, others have maybe 1.5-2MB of them). I have a dedicated server that has 2TB of bandwidth per month, and I'm quickly approaching the 2TB point... what should I do?

Normally, I'd buy more bandwidth... but the host I have charges $400/month for 10mbps unmetered bandwidth -- more than the cost of the server each month! What other options do I have?

View 12 Replies View Related

Running Unmanaged VPS

Apr 30, 2009

I'm looking into purchasing a VPS, and I saw unmanaged are cheaper.

What would I need to know/learn to do maintain an unmanaged VPS?

View 14 Replies View Related

Running Sshfs On A VPS

Apr 15, 2009

I'm trying to run sshfs on my VPS but it seems to require the fuse module compiled on kernel. I already asked my host but they said that they won't change the kernel.

Is there an alternative to sshfs? I really need something to mount an external server.

View 4 Replies View Related

SSH And Running Exe (or Any Other Application)

Jan 5, 2009

I've written an application that acts as a game server for a simple game I'm creating. From what my friends tell me you can't run an exe on a webhost. They did however tell me that you can run java apps on a host that gives ssh access.

View 8 Replies View Related

OpenVZ - SSH Not Running

Jul 22, 2007

If I restart VPS (vzctl stop 1002 | vzctl start 1002 ) I can't join from ssh - not working, but remaining services start correctly: ftp, cpanel, etc.

View 9 Replies View Related

Running A DNS Server

Jan 17, 2008

I currently have one dedicated server and four VPSs all using Plesk and all having their own name servers controlled by Plesk. What I'd like to do is consolidate everything so all my sites use one set of name servers.

I'm a PHP developer (and will be developing my own front end), and only have limited knowledge of administrating a server, so first of all if anyone has done this before and made mistakes in the process, please could you share them with me so I can avoid making them?

Secondly, I would like to use a MySQL database for storing the DNS info - I've found a tutorial at [url]which I'd like to use - could someone who knows what they're talking about have a skim through this and reassure me that everything there is correct and up to date (the article was written in early 2006 - just checking nothing in the world of DNS has changed since)?

I'm using Fedora.

View 0 Replies View Related

Named Already Running

Jun 10, 2008

I keep getting this error when trying to start named, bind 9.3.3 installed through yum (centos 5 x64).

# service named restart
Stopping named: [FAILED]
Starting named: named: already running [FAILED]

# ls /var/run/named
#

# ls /var/lock/subsys | grep named
#

I even uninstalled bind, restarted the system, and reinstalled and it is still giving me the same error.

There aren't any related errors in dmesg/messages and I couldn't find a named related file in /var/log.

View 4 Replies View Related

Xen On Running Server

Nov 13, 2008

I've a production server running web,smtp, ftp, cpanel...

Now I need to run different solutions on the same server (like PABX, games), of course I can't put all on the same place (to better control security, resource usage etc..)
Is it possible to install xen without affecting my production environment? It would be a good choice doing that?

View 10 Replies View Related

Couriertcpd Is Not Running

Jun 20, 2008

We have an OpenVZ VPS, And we have a problem with courier there.

The issue is that when we reboot the VPS, then we see the following error when trying to restart IMAP:

imap has failed, please contact the sysadmin (result was "couriertcpd is not running").

But if we use the following cPanel script, that get resolved until we reboot it (the vps) again:

/scripts/convert2maildir

* We have converted to maildir in the past, but should use that script and choose "3" option to get the issue resolved temporarily.

* I try to start courier with /scripts/courierup --force but that doesnt fix the issue.

* There is some other issues on that VPS which may be related to this one:

- We cannot modify the date on that VPS, I dont know why, It doesnt change ever.

- The results of mkpasswd root command is the same everytime we use it.

Operating System: CentOS 4.6

Control Panel: cPanel 11.23.2

Node Platform: OpenVZ

View 1 Replies View Related

Running Web Server

Aug 13, 2008

I want to start up my web server again. I have Windows XP hosting my web server right now. and, it's slow.
Should i stick with Windows, run IIS and use httpZip from Port80?
I really like microsoft, and don't want to change and adapt to something else.
give me advice

Or, should I run Linux
I would run Linux on it, but I don't know how.
And they have different version of Linux. Example Redhat, Ubuntu etc.
Which one should I go for?

Also, what do I do if I have a netgear ethernet card? Is that Linux? Is it compaitable with Redhat?

And last question, what do I use for security?
I'm a hacker, yeah.. I know what all people can do to websites. How do I stop them?
DoSing, Cross Scripting, XML Attacks, MySql Injection.. Etc.

If a linux fan can respond, that would be nice.

View 4 Replies View Related

Running Zend On IIS 6.0

Aug 20, 2008

I'm not sure if this is the best board for this question but I'll try anyway. We recently had an app built and the developer built it using the Zend framework.

Our server is running IIS. Does anyone have a link to information or know any tricks in getting Zend build apps to work on IIS?

We need to stick to IIS because other apps we have were built in asp so switching to apache is not an option.

View 0 Replies View Related

Those Running DirectAdmin On VPS

Jun 25, 2008

may I know which version of apache and mysql are you running on your production server? Will the latest apache or mysql conflict with DA?

View 9 Replies View Related

What Is This Running Process

Feb 19, 2008

I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL

View 3 Replies View Related

Running Your Own Server

Jul 18, 2008

why not just setup my own server. I have the connection and hardware necessary. So I am wondering why do people pay for web hosting? Why not just run your own website from your own server?

View 15 Replies View Related

Running A Vpn Service

Dec 10, 2008

I am thinking of running a vpn service for a limited number of my clients, so that they can surf the web securely and anonymously through our VPS (routing all traffics through a vps). However I have no idea what features should I looking for, I mean how much BW or ram does it need.

Lets say I have 10~20 clients at all, Is a VPS with 300G monthly BW and 256(or 512)M of ram enough to have it work smoothly?

View 8 Replies View Related







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