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

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 RH

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

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

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

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 an

[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

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 wrote: > Hi All, > > I 'm testing a HA solution for a PG version 9.01 database configured u

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

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

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 direct

[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

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:

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

[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 ..."

[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

| 15 MB (20 rows) 4. Where are the rest of 5,5 GB been used ? How can I get the system catalog correct size ? Thank you, Isabella Tom Lane wrote: > > Isabella Ghiurea writes: > > I'm trying to understand why there are GB's difference when checking > > f

Re: [ADMIN] db size and tables size difference

ystem catalog correct size ? Thank you, Isabella Tom Lane wrote: Isabella Ghiurea 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 countin

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

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

[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] 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. Ghiurea

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

[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

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

[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

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 ? O

Re: [ADMIN] change user passwd

'password'; / 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 Th

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

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

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

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