When 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.
does anyone know about a windows web host with postgresql database (possibly running 8.4) and .net 3.5 ?
View 4 Replies View RelatedI 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.
i'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
i 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
I 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.
I 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 RelatedI wanted to get a sense of the usage of Postgres versus MySQL. Does anyone here prefer Postgres over MySQL?
View 14 Replies View Relatedfor 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?
way to upgrade postgresql 7.4 to 8.1, i heard that V8 is less consuming
View 6 Replies View Relatedi cant find Postgresql log file
can any1 tell where to find it (v. 7.3)
i have cpanel,virtuozzo installed
Transferred 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"
I 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)
The 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!
where 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 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 RelatedI 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)
As 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.
A 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 RelatedHaven'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.
I 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 Related