• PostgreSQL to SQL Server database migration

    Our department has a PostgreSQL database that we need to move over to SQL Server. That includes both the schema and all the data. It's becoming a very slow process manually and we need something automatically. What should we do here? We're currently moving over the tables one-by-one.

    ITKE409,400 pointsBadges:
  • PostgreSQL to MySQL data migration

    I recently changed my database from PostgreSQL to MySQL. But how can I do a data migration from one to the other? Is there a certain command to migrate the database data?

    ITKE409,400 pointsBadges:
  • PostgreSQL error when creating extension: No such file or directory

    When I'm trying to create my extension in PostgreSQL, I keep getting this error message: Could not open extension control file. No such file or directory. How can I fix that? Thanks.

    ITKE409,400 pointsBadges:
  • What is PostgreSQL

    What does PostgreSQL stand for?

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

    ITKE409,400 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!

    ITKE409,400 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.

    ITKE409,400 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.

    ITKE409,400 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!

    ITKE409,400 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!

    ITKE409,400 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).

    ITKE409,400 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...

    ITKE409,400 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...

    ITKE409,400 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?

    ITKE409,400 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.

    ITKE409,400 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!

    ITKE409,400 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?

    ITKE409,400 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:

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.

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

Following