• Allowing remote access to PostgreSQL database

    We have PostgreSQL and Windows 7 installed on my machine, followed by having Windows XP on our department's virtual machine. Would there to connect these databases? Also - would about allowing remote access so we can edit the database from each machine? Thank you.

    ITKE436,030 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:
  • 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.

    ITKE436,030 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.

    ITKE436,030 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.

    ITKE436,030 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.

    ITKE436,030 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.

    ITKE436,030 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.

    ITKE436,030 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.

    ITKE436,030 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?

    ITKE436,030 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.

    ITKE436,030 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?

    ITKE436,030 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!

    ITKE436,030 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.

    ITKE436,030 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.

    ITKE436,030 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!

    ITKE436,030 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!

    ITKE436,030 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