Search Results

Search found 1505 results on 61 pages for 'postgresql'.

Page 7/61 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >

• Web based database administration and browsing for PostgreSQL

  - by peperg

  Do you know any free or affodrable web based database administration and browsing tool for PostgreSQL? Something like phpMyAdmin for MySQL and better than phpPgAdmin. For MySQL I found Chive that looks promissing. I'm looking for something similiar for PostgreSQL.

  Read the article

• PostgreSQL compare databases tool or generating migration script util

  - by opedge

  In our development we use two servers with PostgreSQL 8.4 - development and production. So, after changes were made on development server we would like to automatically generate SQL migration scripts. I found that EMS DB Comparer for PostgreSQL can do it, but it is only for Windows (our development team use Ubuntu for developing). Do you now…

  Read the article

• PostgreSQL data comparsion tool

  - by user179056

  Hello, I am looking for a tool/command which can compare data between two PostgreSQL databases. The reason to do this is to have some external verification that the SQL script responsible for data migration from one PostgreSQL database to the other have been written correctly. Any pointers would be appreciated regards Sameer

  Read the article

• postgresql: Fast way to update the latest inserted row

  - by Anonymous

  What is the best way to modify the latest added row without using a temporary table. E.g. the table structure is id | text | date My current approach would be an insert with the postgresql specific command "returning id" so that I can update the table afterwards with update myTable set date='2013-11-11' where id = lastRow However I…

  Read the article

• Convert PostgreSQL array to PHP array

  - by EarthMind

  I have trouble reading Postgresql arrays in PHP. I have tried explode(), but this breaks arrays containing commas in strings, and str_getcsv() but it's also no good as PostgreSQL doesn't quote the Japanese strings. Not working: explode(',', trim($pgArray, '{}')); str_getcsv( trim($pgArray, '{}') );

  Read the article

• How can I hash passwords in postgresql?

  - by Tchalvak

  I need to hash some passwords with salt on postgresql, and I haven't been able to find any relevant documentation on how to get that done. So how can I hash passwords (with some salts) in postgresql?

  Read the article

• Postgresql performance on EC2/EBS

  - by matija

  What gives best performance for running PostgreSQL on EC2? EBS in RAID? PGData on /mnt? Do you have any preferences or experiences? Main "plus" for running pgsql on EBS is switching from one to another instances. Can this be the reason to be slower that /mnt partition? PS. im running postgresql 8.4 with datas/size about 50G, amazon ec2…

  Read the article

• How to read postgresql dump file in Python

  - by xorsyst

  I'd like my Python script to read some data out of a postgresql dump file. The Python will be running on a system without postgresql, and needs to process the data in a dump file. It looks fairly straightforward to parse the CREATE TABLE calls to find the column names, then the INSERT INTO rows to build the contents. But I'm sure there…

  Read the article

• PostgreSQL vs Postgres Plus

  - by Zoltan

  Does anyone know what substantial differences there are between the regular PostgreSQL (www.postgresql.org) and Postgres Plus (http://www.enterprisedb.com/products/postgres_plus.do)?

  Read the article

• PostgreSQL + Rails citext

  - by glebm

  I am trying to move to heroku which uses PostgreSQL 8.4 which has a citext column type which is nice since the app was written for MySQL. Is there any way to use :citext with rails (so that if the migrations are run on MySQL the citext would just use string/text? I found this ticket, but it seems like it isn't going to be a part of…

  Read the article

• PostgreSQL, triggers, and concurrency to enforce a temporal key

  - by Hobbes

  I want to define a trigger in PostgreSQL to check that the inserted row, on a generic table, has the the property: "no other row exists with the same key in the same valid time" (the keys are sequenced keys). In fact, I has already implemented it. But since the trigger has to scan the entire table, now i'm wondering: is there a need…

  Read the article

• Speed up PostGreSQL createdb?

  - by John

  Is there a way to speed up PostgreSQL's createdb command? Normally I wouldn't care, but doing unit testing in Django creates a database every time, and it takes about 5 seconds. I'm using openSUSE 11.2 64-bit, PostgreSQL 8.4.2

  Read the article

• "bad record MAC" SSL error between Java and PortgreSQL

  - by Stéphane Bagnier

  Hello there ! We've got here a problem of random disconnections between our Java apps and our PostgreSQL 8.3 server with a "bad record MAC" SSL error. We run Debian / Lenny on both side. On the client side, we see : 2010-03-09 02:36:27,980 WARN org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:100)…

  Read the article

• PostgreSQL automatic backup

  - by Ragnar123

  I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script. However, my jobs are not running like they should. I have set both the schedule, and the steps. I am fairly certain, that I am running the service under a…

  Read the article

• Postgresql 9.2 where is the initdb located on Ubuntu

  - by thanikkal

  I am trying to install postgres on EC2 / EBS. I am following this article and stuck at the following step. sudo su - su postgres - /usr/pgsql-9.0/bin/initdb -D /pgdata I cant find the initdb command located at the stated location, matter of fact i cant find the pgsql* directory at all under /usr folder. Was this changed for…

  Read the article

• OpenX : mySql VS PostgreSQL

  - by Andreas Grech

  I have been using OpenX's AdServer with mySql as a backend, and since OpenX allows one to choose between mysql and postgres, I was wondering if anyone ever used Postgres and wished to talk about their experience with it here. Also, is there anyone who maybe tried using OpenX with both and can offer a comparison between the…

  Read the article

• Using pg_connect() with wamp server and postgresql

  - by northlandiguana

  Help! I am trying to connect to a Postgres database and can't get the server to connect. When I execute this php script: $conn = pg_connect("dbname=wikimap user=postgres password=postgis host=localhost port=54321"; if (!$conn) { echo "Not connected : " . pg_error(); exit; } I get this error: <b>Fatal…

  Read the article

• Hyperthreading vs. SQL Server & PostgreSQL

  - by IanC

  I have read that hyperthreading is a "performance killer" when it comes to DBs. However, what I read didn't state which CPUs. Further, it mostly indicated that I/O was "cut to < 10% performance". That logically doesn't make sense since I/O is primarily a function of controllers and disks, not CPUs. But then no…

  Read the article

• Installing postgreSQL on Windows XP Embedded

  - by becsystems

  Anyone have some idea how to do this? I am able to install my Win32 application but the postgeSQL install will not work. Any help or at least a starting point would be appreciated.

  Read the article

• simple script to backup PostgreSQL database

  - by Mick

  Hello I write simple batch script to backup postgeSQL databases, but I find one strange problem whether the pg_dump command can specify a password? There is batch script: REM script to backup PostgresSQL databases @ECHO off FOR /f "tokens=1-4 delims=/ " %%i IN ("%date%") DO ( SET dow=%%i SET month=%%j …

  Read the article

• Config postGreSQL pg_hba.conf restric role access

  - by Mathias

  Hello postgre experts. I am completely new to the game but need the following: I Create a new role with login. Let's say: User1 I then create a Database 'User1Database' and set User1 as the owner. User1 has no rights to do anything except for access. Now when I connect using User1 it somehow has access to…

  Read the article

• Disable disk caches in AWS EBS for PostgreSQL?

  - by Alexandr Kurilin

  It's my understanding that, without correctly disabling OS-level and drive-level caching, there is a chance that in case of system failure the Write-Ahead Log might not be saved correctly and in fact might get corrupted, possibly preventing data recovery. I've already made sure that wal_sync_method=fdatasync…

  Read the article

• Configuration Tuning for PostgreSQL 9.1 PostGIS 1.5 Ubuntu 12.04 Server

  - by Martin

  My server performance is poor. At times SSH, top, and other features or commands are very slow to respond, taking several seconds or more. A query that normally takes 5 minutes can sometimes take 30 minutes. The database is mostly being used to do a spatial query (grid and summarize) on approximately 500GB of…

  Read the article

• List of all CREATE operations I made on level of phpMyAdmin or MySQL (PostgreSQL)

  - by dynback.com

  When I am doing something in a schema of tables I want to have a list of changes to put in svn, and execute it by another members of the team. As I understand, there are 2 ways: extract from logs, or implant some code inside phpMyAdmin, maybe there are other ways without coding?

  Read the article

• PostgreSQL configuration (work_mem, effective_cache_size etc.)

  - by JohnHawkins

  :) I know I can base on tutorials that I can find on net, but there are confusing, and I know there are some of Postgres gurus here. My hardware: 2x Intel Xeon E5645 2,40 GHz / 32 GB of RAM / 2xSAS for pg_xlog (RAID1) + 3x2 SAS for rest (RAID10) + BBU and 512 MB of cache. It's gonna be used for one web…

  Read the article

< Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >