Search Results

Search found 3721 results on 149 pages for 'postgresql newbie'.

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

• 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 databases ? I am asking…

  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 error</b>: Call to…

  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 one ever said bugs made…

  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

• 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 all databases. I then…

  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 however I was…

  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 SET day=%%k …

  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 stored data…

  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 project, with…

  Read the article

• PostgreSQL: BYTEA vs OID+Large Object?

  - by mlaverd

  I started an application with Hibernate 3.2 and PostgreSQL 8.4. I have some byte[] fields that were mapped as @Basic (= PG bytea) and others that got mapped as @Lob (=PG Large Object). Why the inconsistency? Because I was a Hibernate noob. Now, those fields are max 4 Kb (but average is 2-3 kb). The PostgreSQL…

  Read the article

• Where is a postgresql 9.1 database stored in ubuntu 12.04?

  - by celenius

  I installed and created a Postgresql database on ubuntu. I then created the database using the following command: sudo su postgres createdb mydatabase However, I can't figure out where the database was initialized. I would like to be able to edit the hba.conf file and postgresl.conf files. When I view the…

  Read the article

• Creating a multi-tenant application using PostgreSQL's schemas and Rails

  - by ramon.tayag

  Stuff I've already figured out I'm learning how to create a multi-tenant application in Rails that serves data from different schemas based on what domain or subdomain is used to view the application. I already have a few concerns answered: How can you get subdomain-fu to work with domains as well? Here's…

  Read the article

• How to stop postgres from autostarting during start up

  - by bcrawl

  I have postgresql 8.4 installed on my desktop. It keeps starting on bootup because I think I used default settings. so I issue /etc/init.d/postgresql stop everytime and sometimes i keep forgetting It has folder paths as, /etc/postgresql/8.4/main /usr/lib/postgresql/8.4 There are a lot of configuration…

  Read the article

• How to stop postgres from autostarting during start up

  - by bcrawl

  I have postgresql 8.4 installed on my desktop. It keeps starting on bootup because I think I used default settings. so I issue /etc/init.d/postgresql stop everytime and sometimes i keep forgetting It has folder paths as, /etc/postgresql/8.4/main /usr/lib/postgresql/8.4 There are a lot of configuration…

  Read the article

• High-quality ERD generator for PostgresQL under Linux?

  - by Dave Jarvis

  Background MySQL Workbench can produce appealing and high-quality ERDs such as: Research I have not found a tool that even comes close for PostgreSQL. Tools I have found: dbVisualizer - Yellow squares. AquaFold - Yellow squares. SQL Developer - Coloured squares. Dia - Coloured squares. SchemaBank -…

  Read the article

• Convert SQLITE SQL dump file to POSTGRESQL

  - by DevX

  I've been doing development using SQLITE database with production in POSTGRESQL. I just updated my local database with a huge amount of data and need to transfer a specific table to the production database. SQLITE outputs a table dump in the following format: BEGIN TRANSACTION; CREATE TABLE…

  Read the article

• Guides for PostgreSQL query tuning?

  - by Joe

  I've found a number of resources that talk about tuning the database server, but I haven't found much on the tuning of the individual queries. For instance, in Oracle, I might try adding hints to ignore indexes or to use sort-merge vs. correlated joins, but I can't find much on tuning…

  Read the article

• Copy a domain in old schema to new schema with a procedure in postgresql

  - by Giri

  How do we copy a domain in old schema to new schema using a procedure in postgresql?

  Read the article

• PostgreSQL Invalid Value for Parameter Warning

  - by gvkv

  In PostgreSQL 8.4.3, I get this error when logging on to one of my databases (adus): WARNING: invalid value for parameter "default_text_search_config": "tsc_markets" which makes sense since executing the command \dF does not list any such configuration (and only lists the…

  Read the article

• Multiple synonym dictionary matches in PostgreSQL full text searching

  - by Ryan VanMiddlesworth

  I am trying to do full text searching in PostgreSQL 8.3. It worked splendidly, so I added in synonym matching (e.g. 'bob' == 'robert') using a synonym dictionary. That works great too. But I've noticed that it apparently only allows a word to have one synonym. That is, 'al'…

  Read the article

• PostgreSQL and PHP forms

  - by MrEnder

  Ok I have a PostgreSQL server with a Database titled brittains_db that I only have PuTTY access to. I can also upload via FTP to the web server which has access to PostgreSQL and the Database somehow... I have made a SQL file named logins.sql CREATE TABLE logins( …

  Read the article

• Why does PostgresQL query performance drop over time, but restored when rebuilding index

  - by Jim Rush

  According to this page in the manual, indexes don't need to be maintained. However, we are running with a PostgresQL table that has a continuous rate of updates, deletes and inserts that over time (a few days) sees a significant query degradation. If we delete and…

  Read the article

• Enabling PostgreSQL support in PHP on Mac OS X

  - by Jordan Scales

  I'm having a terribly difficult time getting the command "pg_connect()" to work properly on my Mac. I'm currently writing a PHP script (to be executed from console) to read a PostgreSQL database and email a report. I've gone into my php.ini file and added …

  Read the article

• Hibernate+PostgreSQL throws JDBCConnectionException: Cannot open connection

  - by Omer Salmanoglu

  false true auto thread org.postgresql.Driver 1234 jdbc:postgresql://localhost/postgres postgres public org.hibernate.dialect.PostgreSQLDialect false true org.hibernate.transaction.JDBCTransactionFactory false false false false 100 When I press "Save" button…

  Read the article

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