Re: [ADMIN] Postgresql Courses

Hi, check Enterprise DB website (see link ) for on- demand DBA PG SQL admin training, I found them pretty good compared with other two N. America vendors which will provide same web based class in English and Spanish.. http://www.enterprisedb.com/store/products/dba-training Isabella

Re: [ADMIN] auto vacuum errors

a7.7988,6,,2012-07-05 07:45:59 PDT,19/2481,0,ERROR,58P01,"could not open relation 26384/247389/248174: No such file or directory","automatic vacuum of table ""contrib_regression.public.spheretmp6""",,, On 07/04/2012 09:18 PM, Tom Lane wrote: Isabell

[ADMIN] auto vacuum errors

nning PGSQL 8.3.6 on RHES. Isabella -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Insti

[ADMIN] PG 9.1 Replication class advise

but they can't offer what I'm interested, any one there can recommendations for this type of class ? Thank you Isabella -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre |http://www.nrc

[ADMIN] snapshot backup with WAL files

s . During this time the full pg db read/writes will continue. Are any loss of data we should may be aware during this backup procedure? env :RHES-64 bits with LVM directories, PG 9.0, the db size >150GB Thank you Isabella | -- --- Isabel

[ADMIN] PG 9.0.1 database errors

1-1]LOG: incomplete startup packet 2011-07-25 07:27:24 PDT[935]:[1-1]ERROR: invalid page header in block 5665176 of relation pg_tblspc/16390/PG_9.0_201008051/16393/16453 2011-07-25 07:27:24 PDT[935]:[2-1]CONTEXT: automatic vacuum of table "ICAT.irod.r_data_

[ADMIN] PG 8.4 and identity columns

r choice? Thank you Isabella -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Ast

Re: [ADMIN] Heartbeat + pacemaker configuration for PostgreSQL log shipping

es aka :Pg data, log files corruption. Hope this may help with your decision, Isabella -- View this message in context: http://postgresql.1045698.n5.nabble.com/Heartbeat-pacemaker-configuration-for-PostgreSQL-log-shipping-tp3394494p3396099.html Sent from the PostgreSQL - admin mailing list a

[ADMIN] monitor SQL activity in db

Hi Gurus, I'm running PG 9.0.1 and have some issues with some SQL, I would like to know if are other system views/tables beside the pg_stat_activity from where I can get details about a running transactions / SQL at given time. Thank you Isa

Re: [ADMIN] PG HA solution using DBRD

each server. Isabella [email protected] wrote: Hi, What king of configuration do you have on DRBD? is it Primary/primary or Primary secondary? On Nov 10, 2010 12:12am, Isabella Ghiurea wrote: > Hi All, > > I 'm testing a HA solution for a PG version 9.01 database configured u

[ADMIN] PG HA solution using DBRD

p process (PID 8505) was terminated by signal 6: Aborted 2010-11-09 13:20:03 PST [8499]: [3-1] LOG: aborting startup due to startup process failure postg...@proc5-15:errorlog

[ADMIN] PG 9.0 streaming replication cfg question

and loaded on standby server ? Thank you Isabella -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of C

Re: [ADMIN] WAL log shipping + Streaming replication PG 9.0 questions

Fujii Masao wrote: On Tue, Oct 19, 2010 at 2:48 AM, Isabella Ghiurea wrote: I have some questions regarding hot standby + streaming replication (PG 9.0) : what is master/primary server behavior if archive_command fails due to archive directory off line/unavailable

[ADMIN] WAL log shipping + Streaming replication PG 9.0 questions

directory not available? Thank you Isabella -- --- -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] virtual ip's for Pg host

Hi All we would like to implement a virtual ip for two of our of our PG db hosts to help us with switching hosts with less downtime for clients, is there any specific change need to be done on PG database hosts configuration , I was thinking maybe pg_hba.conf file ? Thank you Isabella

Re: [ADMIN] PG 9.0.1 upgrade issues

Devrim GÜNDÜZ wrote: On Fri, 2010-10-15 at 12:18 -0700, Isabella Ghiurea wrote: I have upgrade my existing env PG 8.4.4 to PG 9.0.1 , run a dump and restore and recreate the table space. The upgrade went smooth no issues until I restart the db and I see this in PG erorrlog, any ideas if

[ADMIN] PG 9.0.1 upgrade issues

p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16506 ORDER BY t.tgname -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research

[ADMIN] vacuumdb for schema only

Hi List, I would like to know if there is an option to run full vacuumdb for a specific schema only, I see there is option for tables or whole db . Thank you Isabella -- --- Isabella A. Ghiurea [email protected]

[ADMIN] functions details

Hi PGList, How can I get details about functions (using C lib) inside db aka: creation date and DDL, in PG version 8.3.6 . Thank you Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] overwrite permissions on default tablespace

ession level "set default ..." is not to 'satisfactory' approach for us. Thank you Isabella -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/ser

[ADMIN] db size and tables size difference

Tom Lane wrote: Isabella Ghiurea writes: > The issue may be with pg_size_pretty() results, I don't have details > knowledge of this function. I doubt it, that's a pretty simple function ... but if you don't trust it, just remove the pg_size_pretty call and look dire

Re: [ADMIN] db size and tables size difference

elect pg_size_pretty(pg_database_size('db1')); pg_size_pretty ---- 12 GB Isabella Isabella Ghiurea wrote: > > Hi All, > Tom, please see bellow are the results for the modified query with > ORDER BY > > select pg_size_pretty(pg_database_size(

Re: [ADMIN] db size and tables size difference

| 16 kB tap_schema.tables_pkey | 16 kB Thank you Isabella Hi All, Please, see more info my env: PG 8.3.6 on RHE5-64bits. 1. there are more than one schemas, but the size of the tables is close to 30-40kB, se

Re: [ADMIN] db size and tables size difference

om.metric | 70 MB caom.polarizationentity | 33 MB caom.simpleobservation_i2 | 25 MB caom.plane_psi1 | 23 MB caom.metric_i2| 18 MB caom.metric_i1| 18 MB caom.plane_position_i3| 15 MB (20 rows) 4. Where are the rest of 5,5 GB been used ? How can I get the s

[ADMIN] db size and tables size difference

aom.plane_time_i1| 58 MB caom.plane_position_i2| 48 MB caom.metric | 33 MB caom.polarizationentity | 29 MB caom.simpleobservation_i2 | 25 MB caom.plane_psi1 | 23 MB caom.metric_i2| 18 MB Thank you Isabella --

Re: [ADMIN] user connection properties

of the Gurus we can add this one to the list. Isabella Kevin Grittner wrote: Scott Mead wrote: > Isabella Ghiurea wrote: >> From which internal tables/views I can get the user connection >> application/job name ? (pg_stat _activity has the client ip >> address onl

[ADMIN] user connection properties

Hello Gurus, From which internal tables/views I can get the user connection application/job name ? (pg_stat _activity has the client ip address only) Thank you Isabella- --- Isabella A. Ghiurea [email protected]

[ADMIN] terminate PG connections

#x27;t want to use the OS " kill " ) Thank you Isabella -- --- Isabella A. Ghiurea [email protected] Canadian Astronomy Data Centre | http://www1.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/ National Research Council of C

[ADMIN] configure PG clients for DNS

Hello Pg Gurus, I would like to know how can I configure PG clients in pg_hba.conf to use DNS entries ( aka domain/host names) insted of ip's/CIDR-ADDRESS . my env: PG version 8.3.6 on RHES 5.1 Thank you Isabella --- Isabe

[ADMIN] pg error log file monitor

Hi Gurus, I'm looking if some has a script to monitor the PG database error log (*.log) , if ther are any new messages/errors written to this file to get an email or kind of notification. Thank you -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your sub

Re: [ADMIN] psqlrc file on RHEL5

Thank you, but my problem is : psql can't make use of readline cmd line history. I don't have a .psql_history file in my .~/ dir. I installed/upgrade PG 8.3.6 from tarball as user postgress, psql will conect to db but not history cmd line so far...any tips ? OS: RHEL 5-64 bits ldd /opt/pgsq

Re: [ADMIN] issues with psql after upgrade

l/ --with-includes=/usr/include/ --with-libs=/usr/include/readline/ make all make install thank you Isabell a Tom Lane wrote: Isabella Ghiurea writes: > My concern is after a PG upgrade to 8.3.6 the psql behavior has been > changed : can't use history line anymore . Apparently y

[ADMIN] issues with psql after upgrade

file ( source code) with .confgure --with -inlude=/usr/inlude/readline thank you Isabella Vladimir Rusinov wrote: On Tue, Feb 24, 2009 at 9:51 PM, Isabella Ghiurea <mailto:[email protected]>> wrote: I have installed pg 8.3.6 from source code and I want to con

[ADMIN] psqlrc file on RHEL5

I have installed pg 8.3.6 from source code and I want to configure the psqlrc file , BUT can't find to much tips and documentation: Can anyone provide a good working copy here and the location/path where to store this file > ( /etc/sysconfig/pgsql/is empty !!!) Isabella -- Sent v

[ADMIN] psqlrc cfg file

Hi All, Anyone has a good working copy of psqlrc file to nice configure psql behavior. Thank you Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Upgrade 8.3.6 issues

Thank you , that worked! Isabella Ray Stell wrote: btw, no dump is required to flip from 8.3x to 8.3x, but testing is a good thing. check the postmaster.pid [postgre...@swallowtail alerts_oamp]$ cat postmaster.pid 2545 /var/database/pgsql/alerts_oamp 5478001 0 alerts_oamp]$ ps -ef

[ADMIN] Upgrade 8.3.6 issues

Hi All, I'm testing for the first time a PG upgrade process, presently running 8.3.4 and try to upgrade to 8.3.6. I have installed 8.3.6 in separate dir - run pg_dumpall using the new PG 8.3.6 version - shutdown the server - create a new db cluster with 8.3.6 initdb -copy pg_gba.conf and pos

Re: [ADMIN] Pg 8.3.6 installation

o you have dev installed? $ rpm -qa | grep readline-dev readline-devel-5.1-1.1 On Tue, Feb 17, 2009 at 12:06:17PM -0800, Isabella Ghiurea wrote: > Trying to compile Postgres 8.3.6 and configure fails with readline lib > missing, I have readline installed , please see all info bellow, >

[ADMIN] Pg 8.3.6 installation

Trying to compile Postgres 8.3.6 and configure fails with readline lib missing, I have readline installed , please see all info bellow, OS: Linux RHES x-64 bits installation. postgresql-8.3.6$ locate readline /usr/lib/libreadline.so.5 /usr/lib/libreadline.so.5.1 /usr/lib64/libreadline.so.5 /u

[ADMIN] pgbouncer compilation errors

Hi, I'm trying to install pgbouncer on Linux 64 bits server, and getting a error about :"conftest.c:8:28: error: ac_nonexistent.h: No such file or directory". See bellow all info ,any tips what's missing , i have installed the last libevent patch: ./configure --prefix=/usr/local --with-libevent

[ADMIN] dba and tables spaces questions

valid cmd ? Or other solution to this issues ? using Pg version 8.3 on Linux Thank you in advance Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] change user passwd

Thank you , yes this works in psql . Isabella Suresh Borse wrote: How the remote user access the postgres database. Are they using pgadmin ?? Are they able to connect through psql to remote database? IF yes then try following command dbname=# /alter user "Username" password

[ADMIN] change user passwd

I'm using PG 8.3.4 , what's the method for remote users to change their PG passwd . Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] db restore question/issue

l or I 'm missing something ? Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] connect to psql without passwd

L -U postgres -d test > /var/lib/pgsql//reindex.log thank you Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] autovacuum questions

have configure track_count=true, what values should I go for autovacuum_naptime from your experience? Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] system catalog views + tables

Hello, How can I see all system catalog tables and views , I'm in potsgres db ( using PG 8.3). Is there a way to have /get a full list and description of system tables and views in kind of hard copy format, same as Oracle or RDBMS posters for system catalogs objects? thank you, Isa

[ADMIN] oid2name

where can I download a copy of oid2name source code? Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] PostgresSQL DBA books

I'm looking for advice in purchasing few good DBA Admin books for PostgressSQL , any tips? Isabella -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] DB novice questions

indexes ?( any special syntax , can't find to many examples in PG docs) 3- what is the best practice to use ad owner for a db , if I create the db as user: postgress , any implication for not using this user as owner of all db's ? thank you Isabella -- Sent via pgsql-admin