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

Hi Tom , Here is my error , the missing files were removed by mistake , I have another similar db cfg with this tables:spherrtmp% and no issues. I 'm thinking to restore this tables content from this second db , will this eliminate the auto vacuum error ? 07:45:59.770

[ADMIN] auto vacuum errors

HI Gurus I'm seeing a issue with some temp tables in contrib_regression db , the auto vacuum job will not run for this tables due some files/QID's missing how can I fix this ? The temp tables are growing too fast and they don't get empty/clean-up...any tips ? I 'm running PGSQL 8.3.6 on

[ADMIN] PG 9.1 Replication class advise

Hello Gurus, I 'm looking to gain experience with PG 9.1 replication and want to attend a class which will mainly cover this topic , preferably live instructor and in a learning center( no web based online class). My first choice for location is North America, I looked at EnterpriseDB but

[ADMIN] snapshot backup with WAL files

Hello Gurus, I would like to configure our Pg db for OS file system snapshot backup with Pg WAL files, need to know if would be enough in pg db to call : |*SELECT* *pg_start_backup*('pitr_backup'); and next take the snapshot and after pg_stop the backup and close the WAL files . During

[ADMIN] PG 9.0.1 database errors

Hello Gurus, One of our Pg ver 9.0.1 on RHES 5-64 bits server crashed this weekend, we restarted the db and start seeing the following error, we can't see any disks error in OS error log related to this crashed, no software changes to the system so far I would like to get more info about

[ADMIN] PG 8.4 and identity columns

Hello PGlist, We are interested in migrate some data with identity/sequential columns from a non PG database into PG database , tables with identity columns. First Q is : are system generated/identity columns values supported in PG8.4 if yes, I would like to know if there is a option to

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

Hi, we spend some time looking to use heartbeat Pg 9.0 and warm standby replication option to configure a master/slave system. At the end we have implemented DRBD and STONITH for a master Pg server, DRBD is been used for for all Pg db directories the only exception is the Pg software and

[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 Isabella --

Re: [ADMIN] PG HA solution using DBRD

on each server. Isabella tso...@gmail.com 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 isabella.ghiu...@nrc-cnrc.gc.ca wrote: Hi All, I 'm testing a HA solution for a PG version 9.01 database

[ADMIN] PG HA solution using DBRD

Hi All, I 'm testing a HA solution for a PG version 9.01 database configured using DBRD for pg_xlog directory and user data /table space partitions.( block disk changes are copied from master to slave ) the archive mode option is off for both master and slaver node, when I power off master

[ADMIN] PG 9.0 streaming replication cfg question

Hi All, I'm trying to configure PG 9.0.1 with streaming replication and WAL shipping in same time, what will be pros and cons for using dedicated user for replication aka: replication_user than the regular user :postgres. Any issues with WAL files ownership when they must be copied and

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 isabella.ghiu...@nrc-cnrc.gc.ca 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

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

Hi All, 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? How about standby server behavior if restore command fails due to archive_master

[ADMIN] PG 9.0.1 upgrade issues

Hi All, 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 this is a new table or any changes have been made to this table. ERROR:

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

[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

[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 isabella.ghiu...@nrc-cnrc.gc.ca

[ADMIN] overwrite permissions on default tablespace

Hi PGadmin list, I would like to know how can I overwrite the existing permission( on a default table space) defined in postgresql. cfg with :set default_tablespace =x for a user, trying : revoke all on tablespace x from user doesn't seems to help , the session level set default ... is

[ADMIN] db size and tables size difference

Tom Lane wrote: Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca 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

Re: [ADMIN] db size and tables size difference

Lane wrote: Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca writes: I'm trying to understand why there are GB's difference when checking for db size using pg_size_pretty() and querying for tables + indexes size. . You are not counting everything --- the total DB size is clearly 12GB

Re: [ADMIN] db size and tables size difference

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('db1')); pg_size_pretty 12

[ADMIN] db size and tables size difference

Hi Pg Admin list. I'm trying to understand why there are GB's difference when checking for db size using pg_size_pretty() and querying for tables + indexes size. . The sum of tables +index sizes is showing as aprox 6.5GB and pg_size_pretty(dbname) is coming as 12GB, this are the

Re: [ADMIN] user connection properties

. Isabella Kevin Grittner wrote: Scott Mead scott.li...@enterprisedb.com wrote: Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca wrote: From which internal tables/views I can get the user connection application/job name ? (pg_stat _activity has the client ip address only) Unlike Oracle

[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 isabella.ghiu...@nrc-cnrc.gc.ca

[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 --- Isabella A.

[ADMIN] terminate PG connections

Hello PG Users, I would like to know if there is a clean way to terminate running and idle connections inside PG db ? ( I see : pg_cancel_backend (pid) will send the connections to idle stage but not disconnecting from db , if you have 100 idle connections to db and don't want to use

[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 (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] issues with psql after upgrade

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

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

[ADMIN] issues with psql after upgrade

( 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 isabella.ghiu...@nrc-cnrc.gc.ca mailto:isabella.ghiu...@nrc-cnrc.gc.ca wrote: I have installed pg 8.3.6 from source code and I

[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 via pgsql-admin

[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

Re: [ADMIN] Upgrade 8.3.6 issues

2551 2545 0 Jan11 ?00:00:02 postgres: stats collector process On Wed, Feb 18, 2009 at 08:09:57AM -0800, Isabella Ghiurea wrote: 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

[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 (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[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

Re: [ADMIN] Pg 8.3.6 installation

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, OS: Linux RHES x-64

[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

[ADMIN] dba and tables spaces questions

Dear pg Gurus, I would like to know : 1- how can I alter an existing db on new table space, is there a cmd :alter db add tablespace2 etc ? 2- how can in create db allocate 2 -n tables spaces for a db ? create db name with tablespace 1= .. and tablespace2= will this be a valid cmd ? Or

Re: [ADMIN] change user passwd

'; / In pgadmin tool we can directly edit the user user properties change the password. On Mon, 2008-12-01 at 12:50 -0800, Isabella Ghiurea wrote: I'm using PG 8.3.4 , what's the method for remote users to change their PG passwd . Isabella Thanks Regards, Suresh Borse (DBA

[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 (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] db restore question/issue

Hi All, I 'm running some db backups tests recovery , using pg_dump d name --b - F c - db.backup , when I test my restore using pg_restore dbname and if I run the restore for 2 times in the row for same db the data gets duplicated in tables is this a feature in pgsql or I 'm

[ADMIN] connect to psql without passwd

I'm writing a shell script to run analyze and other jobs as use postgres, having issues passing the passwd in psql is always asking for password, I'm using .pgpass file as argument in psql ( I understood PGPASS is depreciated). My .pgpass file contains only the passwd string not the full

[ADMIN] autovacuum questions

Hello Gurus, I'm new to PG , running PG 8.3 on Linux and reading trough docs is mentioned that in PG vers 8.3 an AUTO vacuum process has been implemented which will run full vacuum on all user and system tables + analyze and there is NO need fro DBA to schedule a crontab job to run

[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, Isabella

[ADMIN] oid2name

where can I download a copy of oid2name source code? Isabella -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) 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 (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] DB novice questions

Hello Gurus, I'm new to Postgress world and before start creating my first database for test. I have some questions, beware I have experience with other RDBMS. 1- when issue create db , is there a option to specify the database page size ? what's the default ? ( don't see any comments in