[GENERAL] New to postgres -' how to' tips needed

Hi, I'm completely new to postgres. My main job will be to install and configure it properly and I'm not sure how much I can rely on the default values. Are there any good articles howto install and configure postgres? I have found the online documentation but need something simple. Any sug

[GENERAL] Postgres in a solaris zone

Hi, Anybody has an experience in running postgres database server from a solaris zone? Do you see any problems with such a setup? Any traps? Thanks, -'\/\/\/`v^v^v^v^v^v^v Nina Markova, Database Analyst

[GENERAL] How to check what is current postgres version

Hi, Is there any way to check the exact current version without issuing 'psql' command? Say, 8.2.1 or 8.2.9? Thanks, Nina

Re: [GENERAL] How to check what is current postgres version

Thanks From: justin [mailto:[EMAIL PROTECTED] Sent: September 8, 2008 13:54 To: Markova, Nina Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to check what is current postgres version select version() Markova, Nina wrote: Hi

[GENERAL] Postgres in a solaris zone - patch 125077-02 needed

Hi, I am working on installing postgres ina zone - zoneadm install command finished with errors : Error: /usr/lib/libkrb5.so.1 not found. Please install the patch for 6381288 (we should expose the krb5 api). The patch needed is 125077-02 for SPARC and 125078-02 for x86 systems. pkgadd: ERROR: che

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

Sent: September 9, 2008 09:43 To: Markova, Nina Cc: Greg Smith; pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed bug_id 6546052 is already fixed in the PostgreSQL 8.2 packages on the Solaris S10 update 4 DVD. The "Fixed in Build: s10u4_07&quo

[GENERAL] 3 postgres processes

Hi, After issuning initdb and starting the postgres server, I checked for processes running, expecting to see just one: postgres 4926 4924 0 14:44:52 ? 0:00 /usr/postgres/8.2/bin/postgres postgres 4924 1 0 14:44:52 pts/1 0:00 /usr/postgres/8.2/bin/postgres postgres

[GENERAL] How to upload data to postgres

Hi again, I need to load data from Ingres database to Postgres database. What's the easiest way? Thanks, Nina

[GENERAL] FW: How to upload data to postgres

the Postgres documentation I only saw how to create an index with a specific structure. In Ingres: modify site to isam unique on sta, ondate (means structure isam, primary key is on 2 fields - sta and ondate) Thanks in advance, Nina > __ > F

Re: [GENERAL] FW: How to upload data to postgres

| not null elev| double precision | not null default 0 regist_code | character(1) | not null default ' '::bpchar Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 9, 2008 22:43 To: pgsql-general@postgresql.org Cc: Marko

Re: [GENERAL] FW: How to upload data to postgres

EMAIL PROTECTED] Sent: September 10, 2008 10:39 To: pgsql-general@postgresql.org Cc: Markova, Nina; [EMAIL PROTECTED] Subject: Re: [GENERAL] FW: How to upload data to postgres On Wednesday 10 September 2008 7:14:50 am Markova, Nina wrote: > Thanks Adrian. > > I have read the Postgres 'cop

Re: [GENERAL] FW: How to upload data to postgres

Adrian, The trick seems to work. Thanks! Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 10, 2008 11:58 To: Markova, Nina Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED] Subject: RE: [GENERAL] FW: How to upload data to postgres

[GENERAL] Psql command for rowcount

Hi, Is there a psql or other command that I can use to list tables and their rows? All I found is this: http://archives.postgresql.org/pgsql-hackers/2004-09/msg00876.php The describe (\d) command (or \td+ ) doesn't show them (I expected tuples count to be there too) - I can only see name, type,

[GENERAL] setting Postgres client

My message didn't get through the 1st time. -Original Message- From: Markova, Nina Sent: September 17, 2008 17:33 To: pgsql-general@postgresql.org Subject: Help on setting Postgres client I have setup a Postgres server (8.2.4) on Solaris 10, for now in the global zone, wi

Re: [GENERAL] setting Postgres client

ives_count = 0 # TCP_KEEPCNT; # 0 selects the system default Should I change something here? Nina -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: September 19, 2008 10:15 To: Markova, Nina Subject: Re: [GENERA

Re: [GENERAL] setting Postgres client

YES! Done - my listen addresses was the default. Thanks Richard! Nina -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: September 19, 2008 11:57 To: Markova, Nina Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] setting Postgres client Markova, Nina wrote

[GENERAL] FW: information about tables via psql

> Hi, > > I am in process of learning psql. I'm trying to extract information > about tables - as many details as possible. Something similar to what > I'm used to see using Ingres RDBMS - table structure, creation date, > number of rows, primary keys, is it journalled, etc. In Ingres in > order