MySQL vs PostgreSQL on Windows
I am torn between PostgreSQL and MySQL. I am forced to install the chosen one on Windows. I especially need ASP.NET Membership and NHibernate as well. ...
postgresql
Does PostgreSQL support transparent compressing of tables (fragments)?
I'm going to store large amount of data (logs) in fragmented PostgreSQL tables (table per day). I would like to compress some of them to save some space on my discs, but I don't want to lose the ability to query them in an usual manner. Does PostgreSQL support such a transparent compression and where can I read about it in more detail? ...
Need a tool to convert postgres database to mysql.
I found the mysql migration toolkit which will migrate the tables.But is there something which will convert the functions as well. ...
migrate data from MS SQL to PostgreSQL?
I've looked around and can't seem to find anything that answers this specific question. What is the simplest way to move data from an MS SQL Server 2005 DB to a Postgres install (8.x)? I've looked into several utilities like "Full Convert Enterprise", etc, and they all fail for one reason or another, ranging from strange errors that ma...
Why does Postgresql fail with Geokit like this??
I've just started playing with geokit with Rails for an app I am building. I have got my recorda getting geocoded, but then when I go into the console to have a look at what I can do it with and it blew up with the following: user is a user object with lat and lng from my database >> Restaurant.find(:all, :origin => user) Restau...
DB2 vs PostgreSQL vs SQL Server
Has anyone used all three of these databases? What are you experiences with them? PostgreSQL is starting to look pretty tempting to use for a project but I'm curious to learn more about it (We're a .NET Shop). I've also heard quite a lot of people being satisfied with DB2. ...
String concatenation operator in Oracle, Postgres and SQL Server
Is there a way to have a common operator for concatenation in Oracle, Postgres and SQL Server. In Oracle we uses '|', postgres uses '||' and sql server uses '+'. I've solved the problem in postgres by adding the custom operator '+' to support string concatenation. Is there a way to add the same operator in Oracle to support string con...
What is the best DBMS for the job?
Just had a discussion at work about the merits of using PostgreSQL over MySQL and vice-versa. Does anyone have any practical experience where there is a valid reason to use one over the other? Some people were saying that Postgre is better for security purposes whereas MySQL is becoming more feature rich... I'm not sure what to make of...
Why is PostgreSQL Harder to Manage/Maintain then other Databases
I am very interested in postgesql because they have a uuid data type. I have done searches around SO and many people say that Postgres is harder to maintain and manage. Why is this? Is it because postgres needs more configuration, is it because postgres does not have a GUI? ...
PHP and Postgres: catching errors?
How should I prepare the code if it something fails? With try-catch statement or? function delete_question ( $question_id ) { $dbconn = pg_connect("host=localhost port=5432 dbname=heoa user=heoa password=123"); // removes questions and its dependencies: answers and tags $result = pg_query_params ( $dbconn, 'DELETE F...
Postgres: insertion and deletion
I sense an easier way to do the code. How can I do the deletion/insertion shorter? // to delete the old tags before inserting new tags $result = pg_query_params ( $dbconn, ...
Postgresql causing "no space on device" error but disks/partitions are not full
I'm getting the following error while running my Rails website and I believe it is causing it to go down. I'm using Passenger and my site is heavily trafficked. When I try to bring it back online, Apache spawns a large number of children and the load on the machine spikes to about 50, and the site becomes extremely slow. I have no shor...
Should I create an index for partition with fixed key?
Some days ago I started using partitioning to make it possible to work with large amount of data. I created master table as documentation suggest, created some child tables which inherit from the master one and then added a constraint for each child table to define the allowed key value. Constraint was like: CHECK (site_id = 'google.co...
Encoding problems with ogr2ogr and Postgis/PostgreSQL database
Hi! In our organization, we handle GIS content in different file formats. I need to put these files into a PostGIS database, and that is done using ogr2ogr. The problem is, that the database is UTF8 encoded, and the files might have a different encoding. I found descriptions of how I can specify the encoding by adding an options param...
Splitting up an interval in weeks in Postgres
Here goes a yet another SQL question about dates… I'm building a calendaring application using PHP and Postgres that would display events spanning days, weeks or possibly months. Each event has a start date and an end date, and selecting them by range is not a problem; however, it would be useful for me if Postgres could split multi-wee...
postgreSQL vacuum temp files?
Hey, I've got a "little" problem. A week ago my database was reaching full disk capasity. I deleted many rows in different tables trying to free up disk space. After wich i tried running a full vacuum wich did not complete. What i want to know is. When i stopped the vacuum from fully compliting does it leave any temp files on the disk...
How do I use GMT times in postgresql?
We are running about in our java code with GregorianCalendar. We would like to persist these in our postgresql database as GMT +0 time in timestamp type columns, but we're not sure how to go about it. Should the fields be with time stamp or without? By a similar token which "current" time postgres function should we be using current_time...
Does PostgreSQL have Good Multilanguage Support on Windows?
I am about to use postgres for my website but want to know if it has good multilanguage support before I spend time with it. ...
php and postgreSQL installation
Hi Guys, I can't fix this problem. I have installed "php-5.2.10-win32-installer.msi" and "apache_2.2.11-win32-x86-no_ssl.msi", and "mysql-4.1.22-win32" on my XP. When I try to use phpinfo print out database support, I can see mysql is there, but not pgsql. I checked my php.ini, there are entries like these: [PHP_MYSQL] extension=php_mys...
Postgresql one db with multiple schemas vs multiple db with one schema
I've been reading this question, but it doesn't help me. Considering db administration, I think one db with multiple schemas is easier to maintain than the other option, but in terms of performance, which one is better?, is there any advantage from one over the other? TIA. ...