• PostgreSQL scrubbing for PCI compliance

    Does anyone know if there's an easy add-on or open source software to do replication on PostgreSQL so we have the data inside be scrubbed for PCI compliance while being replicated? I'm also looking for an instant offering (no lag).

    ITKE366,220 pointsBadges:
  • How to improve the restore performance in PostgreSQL

    For our restore performance in PostgreSQL, we used pg_dump with the default plain format (which worked okay). But then we started to get time / space improvements when using pg_dump -Fc | gzip -9 -c > However, when we tried to create the database anew, the restore took almost half a day to...

    ITKE366,220 pointsBadges:
  • What’s the best method for PostgreSQL incremental backup?

    We've been using pg_dump piped to gzip to split for PostgreSQL backups. But here's the problem: All of the output files are always changed (so basically the checksum-backup copies all of the data). Is there any other way to perform an incremental backup of a PostgreSQL database?

    ITKE366,220 pointsBadges:
  • Restore PostgreSQL backup using the command line

    For the past few weeks (even though I'm pretty new to all of it), I've been working with PostgreSQL. Locally, I've been using PGadmin3. On our remote server, we don't have that luxury. I've created the backup for the database and it was copied over. Would there be a way to restore the backup from...

    ITKE366,220 pointsBadges:
  • Backup PostgreSQL databases on a daily basis

    At my job, I have to backup all of our databases every single week. It's getting pretty tiring. Is there a way to automatically backup our PostgreSQL databases on a daily basis?

    ITKE366,220 pointsBadges:
  • Backup single database table using PostgreSQL

    Hi experts! Does anyone know how to create a backup of a single table, that's within a database, using PostgreSQL? Can I use the pg_dump for this? Thank you very much.

    ITKE366,220 pointsBadges:
  • Automatically backup PostgreSQL database on Linux

    Does anyone know how to automatically backup a PostgreSQL database that's on Linux daily? Thanks so much!

    ITKE366,220 pointsBadges:
  • Can R handle data that’s bigger than RAM?

    I've been using R as open source...but it's not letting me handle data sets that are bigger than RAM memory. Would it be possible to handle big data sets applying PL/R functions inside PostgreSQL? Does anyone know?

    ITKE366,220 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Unable to proceed with bucardo installation

    I'm installing Bucardo to use it with PostgreSQL. My problem is, after I have created a process ID directory, and when I tried to proceed with the installation, I received an error message saying "psql: FATAL: password authentication failed for user "postgres" Sorry, unable to determine the...

    suburbanerrorist5 pointsBadges:
  • How can I reset a sequence in Oracle?

    Does anyone know how to reset a sequence in Oracle? I know that in PostgreSQL, I used this: ALTER SEQUENCE serial RESTART WITH 0; Is there anything like this in Oracle?

    ITKE366,220 pointsBadges:
  • PostgreSQL: Storing old data into a file

    I have an audit function and it returns a trigger. When a row/col is updated it automatically update the db. Now I want to store the old data into a file (after updating by new data) for further reference. How can I make it? Please help me.

    vichuuss5 pointsBadges:
  • How can I select random rows in PostgreSQL?

    I'm looking to get a random selection of rows from PostgreSQL. I've already tried this: select * from table where random() < 0.01; But one of my friends told me to use this: select * from table order by random() limit 1000; My table has over 200 million rows so I need it to be fast. Which way...

    ITKE366,220 pointsBadges:
  • How to do auto-increment values in PostgreSQL

    My department is switching over from MySQL to PostgreSQL and we need some help with auto-incrementing values. We saw in the PostgreSQL document that the datatype "serial" should work but we keep getting errors. Thank you very much.

    ITKE366,220 pointsBadges:
  • How we can import a SQL dump into a PostgreSQL database?

    We're in the process of switching hosts and our old host provided a SQL dump of the PostgreSQL database of our site. Now, we're looking to set it up on a local WAMP server to do some testing. But we're running into an issue with importing that database in the PostgreSQL 9 that we have set up. We've...

    ITKE366,220 pointsBadges:
  • Can I write a case insensitive query for MySQL and PostgreSQL?

    I've been running a MySQL database locally for our development team but it's been deploying to Heroku which currently uses PostgreSQL. Heroku has been handling most everything I need but we use PostgreSQL for case-insensitive statements. What would be the best way for me to write a case-insensitive...

    ITKE366,220 pointsBadges:
  • Can I embed a PostgreSQL database?

    I'm not sure if this is possible but I'm trying to embed a PostgreSQL database. Several employees at our organization told me that it's not possible but I thought I would at least ask here. So basically, I'm looking for a PostgreSQL without the configuration / installation. Appreciate any advice.

    ITKE366,220 pointsBadges:
  • Copying my PostgreSQL database to our development server

    I'm trying to find the easiest way to copy my PostgreSQL database to our development server. What's the best way to do this? Would a dump and restore process work?

    ITKE366,220 pointsBadges:
  • Performance management of databases

    Which tools do you use for database performance management? Does someone used enteros solution for managing performance of MySQL. and PostgreSQL? Please let me know if someone used Enteros Upbeat High Load Capture.

    Saeed54435 pointsBadges:
  • Should I use SQL Server 2008 R2 or Postgre 9?

    I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.

    ITKE366,220 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following