• 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:
  • Exporting PostgreSQL database schema to XML format

    How can I go about exporting my PostgreSQL database schema to an XML format? Is there a certain code I have to use or a tool? Thank you.

    ITKE434,585 pointsBadges:
  • How to view PostgreSQL dump files

    I have to go through a ton of PostgreSQL dump files (this is for their data). Do I have to recover each file one-by-one? Or is there an easy SQL query to see them all? Thanks.

    ITKE434,585 pointsBadges:
  • Convert MySQL syntax to PostgreSQL

    Does anyone know if there's a tool that can help me convert a MySQL syntax to PostgreSQL? Would mysqldump be an option for me? Thank you.

    ITKE434,585 pointsBadges:
  • Connection limit on PostgreSQL database

    On our PostgreSQL database, my partner and I need to find out if a connection limit has been set on a per user basis. We figured out how to set the limit. Now we just need to know if such a limit was set. Thank you.

    ITKE434,585 pointsBadges:
  • Copy PostgreSQL database or schema

    Does anyone know if it's possible to create an actual copy of a PostgreSQL database? Or even the schema? We're looking to do some testing on a particular schema (which has a lot of updates) and we need to copy it because we want to compare it to the original.

    ITKE434,585 pointsBadges:
  • 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.

    ITKE434,585 pointsBadges:
  • What queries are running on my PostgreSQL database?

    I'm running a PostgreSQL database and one of my applications runs queries on it. Is there a way I can see which queries are running on it? The computer I'm running it on is a Linux.

    ITKE434,585 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?

    ITKE434,585 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.

    ITKE434,585 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?

    ITKE434,585 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!

    ITKE434,585 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.

    ITKE434,585 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.

    ITKE434,585 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!

    ITKE434,585 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!

    ITKE434,585 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).

    ITKE434,585 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