|
I've used red-gate's sql compare with sqlserver for checking table/index/proc differences, is there anything similar for postgres?
What I want to do is figure out between development, QA, and production databases if there are any indexes or other schema...
Started by dar on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema This a perl-based script I have used and found handy..
Postgresql/dbcomparer
Check_postgres from bucardo has a schema diff option.
|
|
I have a script that will produce daily rotated backups for mysql, but I can't find anything similar for postgres. I have also discovered that it has an online backup capability, which should come in handy since this is a production site.
Does anyone ...
Started by Stavros Korokithakis on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It uses mysqldump to backup MySQL and pg_dump to backup Postgres.
Source= http://gems.github.com ").
|
|
Is there a way to create a select statement that would retrieve data from multiple database in postgre?
i was thinking it would be something like this:
select * from dbname1.table1, dbname2.table2 where dbname1.table1.column1 = dbname2.table2.column1
Started by warlock22 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Which is incorrect - the PostgreSQL databases contain schemas....
Let's say MySQL.
OTOH it's possible that you treat the databases in a PostgreSQL cluster as equivalent to the databases in...
Have a look at the " dblink " contrib module .
|
Ask your Facebook Friends
|
I am trying to choose between postgre and firebird databasses. The database will be installed on a windows 2003 server with asp.net 3.5. i don't want to use sql server because of price issues and I don't want MySQL I had a bad experience with it and the...
Answer Snippets (Read the full thread at stackoverflow):
I've always been impressed with Postgres; it's traditionally had a more complete feature set (in terms love this database....
(All databases, it seems, deviate in one respect or another, but Postgres is the only one I've.
Standard.
|
|
I'm considering upgrade from Postgres 8.3.3 to 8.4.2 on my machine (it has Windows Vista).
Windows Installer (one click installer) for Postgres 8.4.2 that can be downloaded from enterprisedb.com offers only fresh install (it does not recognizes my current...
Started by WildWezyr on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
I've downloaded and installed v8.4.4 and it seems proper.
Of migrator is for what target version of Postgres.
|
|
I'm going to guess that the answer is no based on the below error message (and this google result ), but is there anyway to perform a cross-database query using postgres?
databaseA=# select * from databaseB.public.someTableName; ERROR: cross-database ...
Started by matt b on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This functionality....
What I ended up doing was using schemas to divide the table space that way I could keep the tables grouped but still query them all .
I have run into this before an came to the same conclusion about cross database queries as you.
|
|
I'm looking to use either Firebird or Postgres in my next development project ... largely because both are available under a BSD-like license.
I found a great comparison of the two database at http://www.amsoftwaredesign.com/pg_vs_fb
But this comparison...
Started by Tedi on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
;)
Ability to query databases on other servers local or remote....
The each No in the Postgres column of the page you cited is still a No, although read-only databases at least one excellent database monitoring tool for Firebird .
|
|
I'm not looking for something like phpPgAdmin or pgAdmin III. I'm looking for something similar to MySQL Workbench. A tool to design databases visually and convert those visual designs into queries that will generate the database. It should also be able...
Started by Randell on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
|
|
I'm running a mySQL database locally for development, but deploying to Heroku which uses postgres. Heroku handles almost everything, except that my case insensitive Like statements become case sensitive. I know I could use iLike statements, but my local...
Started by DA on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
In postgres, you can do this:
SELECT whatever FROM mytable WHERE something ILIKE 'match this';
I'm but should work in both MySQL and postgres:
SELECT whatever FROM mytable WHERE UPPER(something) = UPPER the collations in use by the ....
|
|
Unfortunately setTimeout is not implemented for JDBC/postgres. Is there some way I can simulate or workaround this? Functionally I want to execute the query and the then break if it takes longer than N seconds
Started by deltanovember on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
For your dataSource? It has lots of configurable options, and for cranky databases and networks.
|
