[GENERAL] PostgreSQL and NeXpose Rapid 7 Vulnerbility scanning software

Is anyone using NeXpose Rapid 7 to scan your PostgreSQL databases for vulnerbilities? If so, what authentication are you using to allow it to connect to your database? Or, how are you configuring the software to allow it to connect to the database? Thanks, Sandra Arnold Sr. Database Administ

[GENERAL] Can the log_statement parameter be set at the user level?

Can the log_statement configuration parameter be set at the user level? For auditing purposes I need to capture certain statements being executed by specific accounts. However, there are some accounts that it would be nice not to be logging this information nor is it required. If log_statemen

[GENERAL] FW: 8.4.2 One Click Installer

I need to get a copy of the 8.4.2 Linux 64 bit One Click Installer instead of 8.4.3. The plan is to install the 8.4.2 and then test our Patching procedures when upgrading to 8.4.3. Thanks, Sandra Arnold Sr. Database Admin DOE/OSTI

[GENERAL] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf

I am currently using the pg_hotbackup Perl script to backup my production PostgreSQL database. However, the next production database is going to be close to a terrabyte in size. We feel that a tar cvzf command is not the correct OS backup solution to use. Instead we would like to use lvmsnaps

Re: [GENERAL] Enabling Server Instrumentation on 8.4.1

Thanks. I have ran this script and it looks like it is working. -Original Message- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: Tuesday, November 03, 2009 10:51 AM To: Arnold, Sandra Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Enabling Server Instrumentation on

[GENERAL] Enabling Server Instrumentation on 8.4.1

I am in the process of trying to enable Server Instrumentation on Postgresql 8.4.1. I installed the software using the Linux one-click-installer. I have looked for the sql file that is shown on the screen that comes up when I try to use the Server Status tool in PGAdminIII (see below) but cann

[GENERAL] PLJava not installed for PostgreSQL 8.4 on Solaris 10 x86 64

Is the pljava.so file included in the PostgreSQL 8.4 binary file for Solaris 10 x86 64-bit? If not, where can I go to download this library file? If so, what would cause it to not install during the installation process? Thanks, Sandra Arnold Sr. DBA DOE/OSTI Oak Ridge, TN

Re: [GENERAL] Substitutes for some Oracle packages

...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sam Mason Sent: Thursday, September 17, 2009 4:04 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Substitutes for some Oracle packages On Thu, Sep 17, 2009 at 03:53:36PM -0400, Arnold, Sandra wrote: > We are in

[GENERAL] Substitutes for some Oracle packages

We are in the process of migrating from Oracle to PostgreSQL. One of the things that we are needing to find out is what to use in place of Oracle supplied functionality such as "DBMS_OUTPUT" and "UTL_FILE". We are currently using this type of functionality in Stored Procedures and packages. W

Re: [GENERAL] Limiting records in pg_dump

of looking at PostgreSQL as a solution to replace Oracle. Those high Maintenance and Support cost have made it necessary to find a replacement for Oracle. -Original Message- From: John R Pierce [mailto:pie...@hogranch.com] Sent: Friday, July 31, 2009 1:59 PM To: Arnold, Sandra; pgsql

[GENERAL] Limiting records in pg_dump

Is there a way to just dump records equal to a specific value using pg_dump? In Oracle, you can export data and use a WHERE clause and only pull a range of data. We currently use this in Oracle to load data sets in our Development database. As we move to PostgreSQL we will be wanting to do th

[GENERAL] Error in pgAdminIII

I am getting the following error in pgAdminIII. I receive the error when I double click on a table under a schema that I own. First I can't find any documentation on what this error means. Second, my PostgreSQL account is a superuser account. An error has occurred: ERROR: could not open r