0
votes
1answer
61 views

Installed JDBC drivers into Solr

I am running Solr4 on Jetty9 and I am trying to include the JDBC drivers for both MySQL and PostgreSQL. I'm a little confused about how I do this. I believe these to be the two files I need: ...
0
votes
2answers
72 views

Transferring data but not structure between Postgres and MySQL

I am currently migrating a web application from one platform to a different one, and part of this migration involves moving data from a Postgres DB to a MySQL DB. The table structures will not be the ...
1
vote
1answer
136 views

What are the options for any SQL Multi Master Master replication?

I am looking for a proper way to do Multi Master Master replication. I am currently using MySQL but open to switching to Postgres or Oracle if needed. So far the only solution I find is ...
0
votes
2answers
481 views

How to migrate old redmine server to new one with version upgrade and database change

I am planning to migrate my redmine(1.0.5) to a new machine. With this migration, I would like to upgrade redmine to latest version and change my database from MySQL to Postgresql. My plan A is: ...
0
votes
1answer
92 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
1answer
182 views

A virtual ftp-server for Windows like ProFTPD [closed]

Is there any solution for Windows which allows creating virtual ftp-server with the user's storage in a MySQL or a PostgreSQL database? Something like ProFTPD for Unix. Thanks for any advice and ...
2
votes
5answers
3k views

Fast Database to store 1 Billion records [closed]

I am writing a code to store data and want to store 1 Billion to 10 Billion records or even more. Most importantto this is speed (nearly 10000 - 20000 / records per second), SPACE usage and CRASH ...
1
vote
4answers
2k views

Connect to MySQL trough command line without need root password

I'm building a Bash script for some tasks. One of those tasks is create a MySQL DB from within the same bash script. What I'm doing right now is creating two vars: one for store user name and the ...
0
votes
0answers
226 views

can we convert postgresql dump to mysql dump thorough commandline?

Can I convert a PostgreSQL dump file into a MySQL dump? I tried but I get syntax error. cd\ c: cd "C:\Program Files\MySQL\bin" mysql -u root -proot pause I run this batch file after I put this ...
-1
votes
1answer
144 views

Big SQL database platform that performs well [closed]

I would like to know your opinion on which DBMS (probably SQL) can perform fairly well and not stress the server too much from the CPU / RAM point of view. I'm used to MySQL but I found (maybe it was ...
1
vote
2answers
342 views

How to convert Mysql database to Postgresql in Linux?

I have a large Mysql database containing tens of tables which I need to convert to Postgresql. I have tried a couple of ancient Perl scripts which I found here and there but none of them did the job ...
1
vote
2answers
162 views

How to dump database to be used with no credentials

I am wondering how can I generate a dumped database so that it can be restored without requiring the original database username and password? Ideally I'd like to know the pg_dumpall as well as ...
-6
votes
2answers
95 views

Learning PostgreSQL after using MySQL [closed]

I'm looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I've figured out \l, \d, and \c, but I'm having trouble listing the tables in my MediaWiki ...
-1
votes
4answers
2k views

PostgreSQL vs MySQL: Extremely Different Performance

We were doing a simple test with MySQL 5.5 and PostgreSQL 9.0.4. The test is so simple. we are inserting to table in a loop. we have simple table with one field integer autoincrement primary key and ...
5
votes
1answer
685 views

Should the database connection limit equal the number of processes connecting?

I noticed that PostgreSQL and MySQL have a 100 client connection limit by default. I'm wondering if I should turn this down since the webserver is on the same box and I only have about 20 PHP ...
-1
votes
3answers
2k views

How can I check RAM/CPU utilization by my database?

I am using postgresql. I want to monitor RAM usage of My Database server, is there any query or command which given the RAM usage or CPU usage? Anything regarding MySql will also be helpful. ...
3
votes
3answers
3k views

How to check throughput (query per second) of a database?

I have PostgreSQL dbms. I want to check live throughput of the DBMS. I want to build a graph of throughput which will be updated every 10 seconds. How do I do that? Any suggestion for MySQL will ...
0
votes
3answers
488 views

Is there a fast method for exporting a large table from mysql to postgresql?

I've got a table with around 2.7 million records, 63 fields, and several indexes. I need to be able to get this table from mysql to postgresql quickly (say within an hour). I know mysql can export the ...
2
votes
1answer
147 views

Placing SQL server in a Zend Server environment

our developers want to migrate from individual installations of php, apache and mysql to a more integrated environment. So they decided to switch to ZendServer installed on a VMware Workstation image ...
4
votes
3answers
5k views

Is the community MySQL safe for production use?

Or Will I need to get the enterprise version? This is because I found this on MySQL's site: If you are running a MySQL production level system, we would like to direct your attention to the ...
0
votes
2answers
692 views

Database Web Frontend [closed]

I'm looking for a web frontend for end users of our database (server runs either MySQL or Postgre) for organization-internal contacts and order handling. I've searched the web for free/opensource ...
2
votes
4answers
765 views

MySQL and PostgreSQL on the same hardware

We recently bought some new hardware for a database server which we were intending to dedicate to the operation of PostgreSQL. However now we have the requirement to also run MySQL as some software we ...
16
votes
2answers
10k views

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution? I need the statement because I use it to create the table on an remote server ...
7
votes
3answers
3k views

Postgres vs MySQL: Which one is more difficult to scale out?

From your experience, which database serve is more difficult to scale? MySQL or Postgres? I know MySQL has several out-of-the-box scaling/clustering features, but with Postgres there is none that ...
2
votes
1answer
230 views

PostgreSQL or MySQL for shared hosting

I want to offer SQL shared hosting for customers. Ideally I'd like: access isolation (one user shouldn't see information about other user's databases) SQL disk space quota per SQL user ability to ...
1
vote
2answers
888 views

Storing Hundreds of Millions of Records

My company will be coming into possession of a dataset consisting of approximately 200-300 million records. The source material is csv and is about 150GB uncompressed. We would need to perform an ...
3
votes
3answers
182 views

Suggestions for spatial database systems [closed]

I'm looking for suggestions on a database for large sets of spatial master data. The data itself is not relational, but could be formulated as such. The data as-is is structed as: latitude, ...
0
votes
1answer
532 views

Postgresql vs. MySQL: how do their data sizes compare to each other?

For the same data set, with mostly text data, how do the data (table + index) size of Postgresql compared to that of MySQL? Postgresql uses MVCC, that would suggest its data size would be bigger In ...
10
votes
5answers
9k views

Should I install 32-bit database or 64-bit database?

(I've read a lot about 64-bit versus 32-bit OS/Apps, but this question is specifically in regards to databases.) I'm trying to understand the pros and cons of 32-bit versus 64-bit databases, and ...
0
votes
2answers
327 views

Which database (DBMS) can best utilize multiple cores and more memory?

The databases that I am interested in are: SQL Server 2008, MySQL, and PostgreSQL 9.0. In general, I am wondering which of those would "scale-up" the best. I have read that PostgreSQL used to ...
3
votes
1answer
425 views

Best way to migrate from MySQL to PostgreSQL

I have to migrate a MySQL database to PostgreSQL. I have tried the mysqldump with --compatible = postresql. I have seen that some poeple use ETL like Talend to make the migration but you must describe ...
0
votes
1answer
16 views

List of all CREATE operations I made on level of phpMyAdmin or MySQL (PostgreSQL)

When I am doing something in a schema of tables I want to have a list of changes to put in svn, and execute it by another members of the team. As I understand, there are 2 ways: extract from logs, or ...
8
votes
7answers
2k views

Is MySQL better than PostgreSQL in something?

I know the question sounds provocative, but it really isn't. I'm lately finding MySQL limiting in a lot of areas and liking PostgreSQL more and more. It scales a lot better and it respects the SQL ...
0
votes
1answer
553 views

pgpool for MySQL?

Is there something like pgpool for MySQL? It seems like there ought to be, and it'd be tremendously useful, but I've never heard of one.
2
votes
1answer
433 views

Databases presenting Mandatory Access Control Multilevel Security

I'm looking for fine grained (row and column level) access control in databases. In other words, I'm looking for mandatory access control (MAC), security policies that classify data and users based on ...
1
vote
2answers
765 views

How can I migrate my Redmine deployment from MySQL 5 to PostgeSQL 8.2?

I have full access to both databases, but clearly a MySQL dump file isn't going to import cleanly into Postgres. Are there any good step-by-steps for migrating from MySQL to Postgres?
0
votes
3answers
155 views

Setting up my own hosting

I have a Linode VPS. This means I have root access; well, I thought I'd offer a bit of shared hosting. How do you get started doing this? I'm wanting to give PHP, MySQL, and PostgreSQL. Also, I'm ...
0
votes
2answers
633 views

Is it safe to set MySQL isolation to “Read Uncommitted” (dirty reads) for typical Web usage? Even with replication?

I'm working on a website with typical CRUD web usage pattern: similar to blogs or forums where users create/update contents and other users read the content. Seems like it's OK to set the database's ...
2
votes
2answers
568 views

How do you handle the task of changing the schema of a production MySQL database?

One of the biggest complaints I have heard about MySQL is that it locks up a table if you try to change its schema like adding a column or adding an index. By "locking up the table" does it mean I ...
2
votes
1answer
190 views

Shadowing MySQL and PostgreSQL to each other

I have a project currently based on PostgreSQL 8.1. However, some of the data processing for it needs to happen on a server for which 7.4 is the latest version (for now, only official packages via yum ...
2
votes
2answers
1k views

How do MySQL logs compare to Postgresql logs?

MySQL has quite a few logs: InnoDB transaction log Binary log General query log Error log Slow query log I know about Postgresql's WAL, which is equivalent to InnoDB's transaction log (correct?). ...
0
votes
3answers
772 views

Is MySQL Replication on Windows reliable?

We played a bit with postgresql and slony for a master-slave-slave replication setup on windows. But we hit a wall with failover/switchover which is very unreliable. How about MySQL? How reliable is ...
0
votes
2answers
1k views

MySQl, Postgresql replication comparison

One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag. How does Postgresql handle replication? Does it (or add-on such as slony-I) allow ...
8
votes
4answers
2k views

Fix Control-C in mysql command line programme?

In the mysql command line, pressing Control-C will cancel the programme, and bring you back to bash. In psql, the one for postgres, it will kill the current query and will not stop the psql programme. ...
1
vote
3answers
2k views

Installing and running MySQL and PostgreSQL-8.4 side by side

Are there any configuration or installation hazards to setup both Postgresql-8.4 and MySQL on the same server and running them side by side, other than performance? The server is running Debian etch. ...
21
votes
3answers
5k views

Postgres equivalent to MySQL's \G?

Does anyone know if Postgres has a way to display query results "prettily", like how MySQL does when ending a query with \G on the command line? For instance, "select * from sometable\G" as opposed ...
2
votes
1answer
1k views

Request Tracker migrate PostgreSQL to MySQL

I am in the process of migrating a request tracker 3.6 instance from one server to another. The old server uses PostgreSQL and the new one will use MySQL. Is there a way to migrate the data from one ...
15
votes
4answers
4k views

Which database server scales better: PostgreSQL or MySQL?

I'm working on a website that could eventually have a very large database. The website will be an art community not until deviantART. I'll be running a lot of queries for analyzing how the site is ...