I have a script that will produce daily rotated backups for mysql, but I can't find anything similar for postgres. I have also discovered that it has an online backup capability, which should come in handy since this is a production site. Does anyone know of a program/script that will help me, or even a way to do it? Thanks. ...
Title says it all. I know this is a good idea in MySQL so I was just wondering if it mattered here? If I recall correctly, in MySQL it allows indexes to work more efficiently. ...
I have a problem installing PL/Ruby for PostgreSQL 8.4 on Windows XP PostgreSQL 8.4 is installed and working OK Ruby-186-27 is installed and working OK I have MinGW installed and I'm using MSYS as the command line shell I have downloaded plruby-0.5.3 and unzipped. My PostreSQL is in C:\Program Files\PostgreSQL\8.4 I've created a record...
Problem: A relational database (Postgres) storing timeseries data of various measurement values. Each measurement value can have a specific "measurement type" (e.g. temperature, dissolved oxygen, etc) and can have specific "measurement units" (e.g. Fahrenheit/Celsius/Kelvin, percent/milligrams per liter, etc). Question: Has anyone bui...
hi I want to use a postgres database for 2 rails projects and for some php blogs. Does anybody have tips for me, which pg gem I should install for ruby? I'm searching also for some general postgres config tips. I run Ubuntu 9.04 as Server. Maybe a (not outdated) good tutorial would be great :) thanks guys ...
In a SELECT call we are returning two different timestamps, but because each column is each called 'timetag' we cannot differentiate between them in the results. The obvious solution of renaming one of the columns will result in a large amount of refactoring which we want to avoid. Our query looks something like this: DECLARE p_cur...
I am using ECPG with PostgreSQL 8.4. I have a function which takes a struct containing pointers to a couple of dynamically allocated, "null"-terminated arrays of integers (I have defined null in this case to be -1, as there is no need for negative values, as in #define INT_ARR_NULL -1 struct foobar { int * foo; int * bar; }; v...
Hello, I have a performance issue when selecting data in my project. There is a table with 3 columns: "id","time" and "group" The ids are just unique ids as usual. The time is the creation date of the entry. The group is there to cummulate certain entries together. So the table data may look like this: ID | TIME | GROUP -----...
Is it possible to send data on a socket over a TCP?IP connection from a PostgreSQL stored procedure or trigger? If you know of any useful examples pleas tell me. If you know of something similar for other data base systems it would also be helpful. Thanks in advance. ...
I am doing ETL for log files into a PostgreSQL database, and want to learn more about the various approaches used to optimize performance of loading data into a simple star schema. To put the question in context, here's an overview of what I do currently: Drop all foreign key and unique constraints Import the data (~100 million reco...
I'm looking to copy a production postgres database to a development server. What's the quickest, easiest way to go about doing this? ...
I'm in a situation where I have many connections that are "IDLE in transaction". I spotted them myself. I could kill them, but that wouldn't prevent them from happening again. In fact, it happens regularily. Is there a way to get the list of SQL statements that were previously executed as part of a given transaction? If I could get tha...
I was just asked to create a report that slices and dices data. We are using postgres. Our schema is setup for OLTP. The system contains orders, they have one status (out of 15+). Orders are also decorated with various properties (8+). The properties are stored in a key/value child table (because they change all the time). End us...
I will soon be switching from sqlite3 to either postgres or mysql. What should I consider when making this decision? Is mysql more suited for Rails than postgres in some areas and/or vice versa? Or, as I somewhat suspect, does it not really matter either way? Another factor that might play into my decision is the availability of tools t...
How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres? My code looks as follow ALTER TABLE n_domains ADD COLUMN contract_nr int after owner_id ...
My table question_id | title | user_id | +---------------+---------------------------------+----------------+ Its types are Column | Type | Modifiers --------------------------------------...
I want to write application which uses Postgresql as DBMS. To write client application do I need libpq library and header files? If yes where I would get libpq library and header files. Thanks and Regards Devara Gudda ...
may be duplicate I am using PHP and postgres. How can I separate words in the form below? The maximun amount of words is 7. word_1, word_2, word_3, ... ...
If I have fields of NVARCHAR (or NTEXT) data type in a Microsoft SQL Server database, what would be the equivalent data type in a PostgreSQL database? ...
I would like to have all variables accessible of the file *handler_login.php* which I include in the file *handler_question.php*. The *handler_question.php* processes the data from the following form. My form_question.php <form method="post" action="handler-question.php"> <p>Title: <input name="question_title" type="text" c...