Embracing the whole Web 2.0 thing, one of my cow-orkers has been playing with his Mac and produced a nice video walkthrough of pgAdmin, showing how to get started and use a variety of the really cool features it has to offer Postgres ... read more

PostgreSQL 0 comments

CREATE TABLE books ( book_id bigint, book_title varchar(100), CONSTRAINT books_book_id_pkey PRIMARY KEY (book_id) )WITH OIDS; CREATE TABLE authors ( id bigint, book_id bigint, author_name varchar(100), CONSTRAINT authors_id_pkey PRIMARY KEY ... read more

PostgreSQL 0 comments

I have a machine running Ubuntu 9.10. I want to install a second hard drive for PostgreSQL and connect to it over my network from my Windows PC. ... I have been searching on how to do this. It is better to get advice from a poker perspective however.. this is a new install and I would like to get it right if possible. ACTIONFREAK is online now ... read more

PostgreSQL 0 comments

An example of how to Delete Database in PostgreSQL How to create databases in PosgreSQL via the Web Hosting Control Panel If you prefer a more graphical interface for database creation, you should check out NTC Hosting's Web Hosting ... read more

PostgreSQL 0 comments

Execute query on a PostgreSql DB Pentaho Data Integration [Kettle] ... Default Execute query on a PostgreSql DB. Hi, I have a problem. I'm a newbe of Kettle. I want to do a query on a PostgreSQL's Database, in this Database there are ... read more

PostgreSQL 0 comments

The database is a PostgreSQL format. The challenge is how to automate the download of this file. I used a CFHTTP call as it allows me to provide a userid/password to authenticate into the Jive Cloud Admin site to retrieve the file. ... read more

PostgreSQL 0 comments

Bruce Momjian parlera des solutions de réplications dans/avec PostgreSQL lors du rassemblement du PUG de New-York le 20 avril de 18h30 à 20h30 au Penn Plaza. Détails et inscriptions ci-après : http://postgresql.meetup.com/3/calendar/ 12788352/ .... section that describes what a standby server is (like the old "Warm Standby Servers for High Availability" section), and how to set up a warm standby server, including streaming replication, using the built-in standby mode. ... read more

PostgreSQL 0 comments

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fetter. Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer Zeit. Bitte sende englische Beiträge an david@fetter.org, deutsche an .... Standby Servers for High Availability" section), and how to set up a warm standby server, including streaming replication, using the built-in standby mode. The pg_standby method is described in another section called "Alternative method for log shipping", ... read more

PostgreSQL 0 comments

PHP tutorial scripts will also let you see how PHP works with. many databases such as MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc. The PHP tutorial script qualification will give you entry into the PHP open ... read more

PostgreSQL 0 comments

Bruce Momjian will be speaking about PostgreSQL Replication Solutions at the NYPUG meeting on April 20th at 6:30-8:30pm at Penn Plaza. Details and RSVP below. http://postgresql.meetup.com/3/calendar/12788352/ .... now a "Log-Shipping Standby Servers" section that describes what a standby server is (like the old "Warm Standby Servers for High Availability" section), and how to set up a warm standby server, including streaming replication, using the built-in standby mode. ... read more

PostgreSQL 0 comments

PostgreSQL is an object-relational database management system (ORDBMS) that is distributed freely, and open source. Just like open source application, the development of PostgreSQL doesn't depend on a company, but managed by a global community. ... There is a rule makes possible how to take and change data; Point-in-time recovery functioned to backup so that if there is destruction on a disk, database can be returned at point where the failure occurred. ... read more

PostgreSQL 0 comments

2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database PostgreSQL Preserving Old Database ... Hmmm. Trust mine to be the problem no one knows how to fix! Grr I am able to save and delete text files on the drive no problem. If I'm reinstalling a program, do I follow your FAQ exactly, even though I'm sharing the database between two computers? ... read more

PostgreSQL 0 comments