Postgresql Log File
Feb 7, 2007i cant find Postgresql log file
can any1 tell where to find it (v. 7.3)
i have cpanel,virtuozzo installed
ADVERTISEMENT
PostgreSQL 8+ And .NET 3.5
Oct 29, 2009does anyone know about a windows web host with postgresql database (possibly running 8.4) and .net 3.5 ?
View 4 Replies View RelatedPostgresql
May 26, 2008I just bought a VPS to do some testing on.
I have cPanel installed, and I did the "/scripts/installpostgres" and the config/password in WHM.
Now when I login to a cPanel account, and create a user or database, it just simply doesn't show up on the page.
Postgresql
Feb 19, 2007i'm having isues with postgresql, 1 on 2 times i get this error:
Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to database on localhost' in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php:96 Stack trace: #0 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php(321): AbstractDb->connect(NULL) #1 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/Server.php(227): AbstractDb->execSqlUniqueRes('SELECT server_i...', NULL, false, true) #2 /home/lavals/public_html/auth1/wifidog-auth/wifidog/include/common.php(107): Server::getCurrentServer(true) #3 /home/lavals/public_html/auth1/wifidog-auth/wifidog/index.php(52): require_once('/home/lavals/pu...') #4 {main} thrown in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php on line 96
the people of wifidog auth server told me to check Ulimit -a and to set it up a bit
but what should i change, here is my curent ulimit -a:
Code:
[/root]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1000
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
what should i boost?
i'm using a VPS with 256Ram, 1meg burst, cpanel,virtuozzo
PostgreSQL
Feb 12, 2007i have a domain running a Wifi auth server, my problem is that i find it very slow when i try to connect to the site.
i know i'm using postgreSQL 7.4, is there a way to speed up the connection?
maybe tweak Postgresql or something,i'm new to this database system.
the link is [url]
i'm running this on a VPS with 256Ram, 1024 burst, cpanel, virtuozzo, OPTERON 246
Postgresql
Jul 18, 2007When I try add data I got this error
INSERT INTO night_prices (id_prices, id_data, id_services, price_oldi, price_weekend, type_prices) VALUES (DEFAULT, 8, 18, '33', '12', 2)
[nativecode=ERROR: permission denied for sequence night_prices_id_prices_seq]
How to fix that?
I have root access.
Tomcat / Postgresql
Dec 3, 2008I would like to install a tomcat application on my domain. Where do I upload the .war file and how can I manage the tomcat and access this application? I have root access to my Cpanel/WHM box. Also, I did apply a servlet already via WHM.
Also, I need to restore my postgres backup file as well but its too big to be done via pgmyadmin. How can I go about doing this via command line?
I'm aware of how to restore a mysql db via command line (1st create db in cpanel, 2nd run command in ssh). Never done so with a postgresql database.
Support For PostgreSQL *and* ASP.NET
Apr 30, 2009I am looking for a webhost with a package that supports both ASP.NET *and* Postgres. So far, I have been able to find ones that support one but not the other.
View 8 Replies View RelatedPostgreSQL Or MySQL
Apr 7, 2008I wanted to get a sense of the usage of Postgres versus MySQL. Does anyone here prefer Postgres over MySQL?
View 14 Replies View RelatedPostgreSQL Performance
Oct 18, 2007for running PostgreSQL on a VPS,
Take a look what moderator of MySource Matrix forums says (enterprise-CMS based on PHP4+pgSQL):
Quote:
Yes, installing onto a virtual server is great, because its like you have an entire server to yourself. However, running PostgreSQL in a VM is not recommended for performance reasons. Obviously this isn't a concern on low-traffic sites. The ultimate solution would be a virtual server for Apache/PHP/MySource Matrix and a dedicated server for PostgreSQL. Though, I don't know of any virtual server providers that also provide dedicated database server access.
(...)
The problem with PostgreSQL (or any database) under virtualisation is that there is no IO prioritization given. So, the database just waits along with everything else for the hypervisor to deliver IO, with no consideration for priorities. This leads to a performance hit of about 70-80%. In testing, we've seen PostgreSQL under VMware ESX/GSX perform horribly, even with fibre-attached SAN storage. Though, sticking PostgreSQL on a Xen DomU seems better. The sysadmins have done some testing on this too.
If you run PostgreSQL across multiple virtual servers on the same hardware, you're just compounding the IO bottlenecks, so I can't recommend it at all.
Source: forums.matrix.squiz.net/index.php?showtopic=3929&st=15&start=15
Can anyone comment and share thoughts on using PostgreSQL on private virtual server?
Upgrading Postgresql
Feb 5, 2007way to upgrade postgresql 7.4 to 8.1, i heard that V8 is less consuming
View 6 Replies View RelatedPostgresql Database Gone After Transfer
Jan 9, 2008Transferred a domain from one cpanel server to another using whm > copy account feature, but now this error arises
---------------
pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "udre" does not exist
---------------
Found this in the copy accounts log
Grabbing PostgreSQL databases............
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
...............
Done
Grabbing PostgreSQL privileges...could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
How To Create Postgresql Latin1
Mar 15, 2007I need to create a postgresql database in latin1 encoding with database name "db" and owner "tobe" and the password I select.
I am using PG v8.x and on cpanel box.
Please kindly list simple, straightforward step by step instructions for ssh method. I've done this a long time ago, can't remember how though.
The db is already created too, just need to convert from utf8 to latin1
I tried this:
-bash-3.00$ createdb --encoding='LATIN1' db
CREATE DATABASE
However, how do I change owner to "tobe"
I see two, one owned by root and other was created by user tobe
-bash-3.00$ psql -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
db | postgres | LATIN1
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
tobe_db | tobe | UTF8
(5 rows)
Error Install Postgresql
Dec 21, 2007The postgresql not start on my server. Use REDHAT Enterprise 4, I tried to install the command:
/scripts /installpostgres
But I returned the following error:
[root@s2 backups]# /scripts/installpostgres
This script will install Postgres 7.3.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.3.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.3.x style setup. Do not do this if
you have databases that you wish to keep!
Are you sure you wish to proceed? y
Fetching Obsoletes list for channel: rhel-i386-es-4...
Fetching rpm headers...
Name Version Rel
----------------------------------------------------------
The following packages you requested were not found:
rh-postgresql
rh-postgresql-devel
rh-postgresql-libs
rh-postgresql-server
The following packages you requested are already updated:
postgresql-libs
postgresql-server
postgresql
postgresql-devel
Stopping postgresql service: [FAILED]
postmaster: no process killed
postmaster: no process killed
Starting postgresql service: [FAILED]
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
PostGreSQL GROWS Out Of Control By ITSELF
Jun 7, 2007where pgsql keeps growing and eating up disk space on my vps.
my vps' disk space is at 4G on the directory:
var/lib/pgsql/data/base/17230
What is causing pgsql to keep growing when I did not even add anything to the vps for days?
logs are not a big problem as they consume only less than 300mb.
Looking For Adult And Proxy Hosting And PostgreSQL
Mar 2, 2008Looking for dedicated server that allows adult and proxy hosting and comes with PostgreSQL. Really looking for a more established host and not some one that’s going to steal my money and run. am open for your ideas on what you think is the best.
View 5 Replies View RelatedPostgreSQL, Big Disk, Modest Bandwidth
Aug 2, 2008I saw the note about Request threads, but I've had no luck with the requester form or sponsors and my requirements are perhaps a little uncommon. I just opened an account with a certain host only to find that the inode thing will be an issue, so already searching for a new place. Recommendations?
I'm flexible on pricing.. up to $20 / month?
My sites:
3x domains
3x Gallery2 installs
20Gb total (~ 70k inodes)
REQUIREMENTS:
PostgreSQL *
PHP 5
30Gb storage (and no harsh inode limit)
5-20Gb traffic (typically closer to 1Gb, if that)
SSH & rsync
PREFERABLE:
PostgreSQL 8.x (many times faster than 7.x)
PHP 5.2.3+ (supports phpdoctrine)
Proper domain management (ability to add arbitrary records)
Professional And Reliable PostgreSQL Hosting In The US
Apr 10, 2008As the topic says, I need a host who knows what they are doing with PostgreSQL and is located in the US.
Budget is $40/month. 40GB+ bandwidth and 2GB+ HDD.
Releasing External Access To PostgreSQL?
May 4, 2007A customer is asking to open the port to access PostgreSQL on a shared server because he needs remote access to his database. Is it a good idea to grant remote access to PostgreSQL?
View 1 Replies View RelatedMySQL/PostgreSQL Servers - Intel Vs AMD
Jun 29, 2007Haven't seen much debate lately on what processors to use within dedicated database servers. We're currently considering Dell 2950s and 2970s with the following:
Two Dual Core AMD Opteron™ 2212
- 2.0GHz, 2X1MB Cache, 1Ghz HyperTransport
Two Quad Core Intel® Xeon® E5310
- 1.60GHz, 2x4MB Cache, 1066MHz FSB
8GB RAM, single SAS, 3.5-inch, 15K RPM Hard Drive for OS, single SAS, 3.5-inch, 15K RPM Hard Drive for SWAP, and four SAS, 3.5-inch, 15K RPM Hard Drives in a RAID10 array for database storage.
We'll be getting one server just for MySQL applications and one server for just PostgreSQL applications.
Apache :: PHP Couldn't Access PostgreSQL
Jan 26, 2013I have installed Apache 2.4.3, and PHP 5.4.5 64-bit, and I have installed PostgreSQL 9.2 64-bits under my new system windows 7 64 bits. Apache and PHP could work nicely, and PostgreSQL run fine too. However, PHP couldn't access the PostgreSQL. pg_connect(), and followed by echo select version(), didn't give any error. When PostgreSQL module was not loaded (because my php dir was d:php, but inside httpd.conf i type D:/PHP), I got message saying something like "undefined pg_connect()." I fixed it, but select version() or any other echo after pg_connect() didn't give any output.
View 5 Replies View RelatedPlesk 12.x / Linux :: Deny User Upload File Via File Manager Or Hidden File Tab?
Feb 10, 2015I'm build Plesk Panel for Linux and Presence Builder, I don't want my user can upload their website to hosting via File Manager. How can I do it...
View 2 Replies View Related1.com/file.php, 2.com/file.php Where File.php Is Hosted On Main.com/file.php
May 26, 2008Say I have 2 websites and they all use file.php which is located on mainserver.com/file.php.
I want to use the file like this:
website1.com/file.php
website2.com/file.php
Ffmpeg :: Cannot Open Shared Object File: No Such File Or Directory In Unknown On Line 0
Mar 6, 2008Rapidly growing error logs showing the same message
$ug-non-zts-20020429/ffmpeg.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//usr/local/lib/php/extensions/no-debug-non-zts-20020429/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
Using cpanel 11 / centos 4
How Can I Show Hidden File In Cpanel File Management Tool
Jun 16, 2008i have a server with centos,
i need to edit the hidden file .htaccess from the file management tool of cpanel,
but the hidden files not shown,
ow can i modify the setting and let the files shown in the file management tool of cpanel?
Plesk 12.x / Windows :: STOP Resetting File Permissions On DLL File?
Sep 17, 2014How can we stop Plesk resetting the file permissions on a dll file that is found in
C:Program Files (x86)
??
Specifically,
we have a file, jmail.dll,
here
C:Program Files (x86)Dimacw3JMail
By default Plesk permissions are set to DENY for PSACLN.
But the JMail plugin cannot work with these permissions !
We change this to be ALLOW for READ & EXECUTE and DENY for WRITE.
And everything works fine.
But every time Plesk does an update it reverts it back !
This means that a number of our customers contact forms stop working !