• 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?

    ITKE407,295 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:
  • MySQL or PostgreSQL for block storage volume

    I was wondering if I could have 2 VP MySQL servers and one SQL database located on a block storage volume. Then I can mount the same volume on both servers reading and writing to a singe database so I can have two VP MySQL machines access and running one database. Thanks

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

    Hello, Does anyone happen to know if I could reset a sequence in Oracle? I understand how to do it in PostgreSQL: ALTER SEQUENCE serial RESTART WITH 0; Thank you very much!

    ITKE407,295 pointsBadges:
  • Where is the data directory located in PostgreSQL?

    I just started using PostgreSQL again but I have forgotten several things. Particularly, where is the data directory located? I tried using /usr/local/postgres/ but it still doesn't exist. Thanks for the help.

    ITKE407,295 pointsBadges:
  • PostgreSQL: List all databases and tables

    I'm pretty new to PostgreSQL and I've just started to learn more administration techniques (including the PSQL command line). Now, when I login with psql --username=postgres, how can I list all databases and tables? Thank you very much.

    ITKE407,295 pointsBadges:
  • Timing SQL queries with PSQL

    I'm using a PostgreSQL database and I have to benchmark several SQL queries against it. Would there be a way I can actually 'time' my queries using PSQL? Thanks!

    ITKE407,295 pointsBadges:
  • Listing all schemas in PostgreSQL

    I'm using PostgreSQL and I need to figure out how to list all schemas using SQL. Can anyone help me? I tried using the below code but it didn't work. SELECT something FROM pg_blah; Thanks!

    ITKE407,295 pointsBadges:
  • 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).

    ITKE407,295 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...

    ITKE407,295 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...

    ITKE407,295 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?

    ITKE407,295 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.

    ITKE407,295 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!

    ITKE407,295 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?

    ITKE407,295 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?

    ITKE407,295 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...

    ITKE407,295 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