[ADMIN] How to extract table DDL from PGSQL database?
Title: How to extract table DDL from PGSQL database? How do I extract table or view DDL from a postgresql database? I thought the PGAdmin tool would do this, but I haven't found the functionality there yet. Looked at the system catalog tables, but didn't find everything I needed (version 7.1 postgresql). Anyone have a script or know of a tool? Thanks. Best regards, David B. Wagoner Database Administrator
[ADMIN] Need PGSQL ODBC Driver for Solaris
Title: Need PGSQL ODBC Driver for Solaris Can anyone tell me where to find a PostgreSQL ODBC driver for Solaris that I can use to share data with an Oracle database? Any suggestions or links to docs appreciated. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com <<...OLE_Obj...>> The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
[ADMIN] Share Data between PostgreSQL and Oracle
Title: Share Data between PostgreSQL and Oracle Anyone have experience doing this? I would like to hear your tips and experiences. Here's our situation. We have an Oracle DB on Sun Solaris 8 and a PostgreSQL DB on Linux (RH 7.3) that we need to share data between, specifically from PostgreSQL to Oracle. I want to experiment with Oracle's Generic Connectivity via ODBC connection. The advantage here seems to be DB-to-DB connection, ability to use Oracle SQL and tools, etc. Limitations might be network performance. An alternative is to produce flat files from PostgreSQL, FTP them to Oracle server, and SQL*Load them into Oracle. Not a real-time solution, but load performance is usually very good with SQL*Loader. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com
Re: [ADMIN] Need PGSQL ODBC Driver for Solaris
Title: Need PGSQL ODBC Driver for Solaris Jeff, Thanks, I saw that page but thought is was only for Windows since it said Win32. But, I'll try it on Solaris and see what happens. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-----From: David Wagoner Sent: Wednesday, October 22, 2003 10:02 AMTo: PGSQL List (E-mail)Subject: [ADMIN] Need PGSQL ODBC Driver for Solaris Can anyone tell me where to find a PostgreSQL ODBC driver for Solaris that I can use to share data with an Oracle database? Any suggestions or links to docs appreciated. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com <<...OLE_Obj...>> The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you.
[ADMIN] Is there a NEW FEATURES section in docs?
Title: Is there a NEW FEATURES section in docs? Hi, I'm looking in the PostgreSQL online docs and do not see a section for New Features. Is there such documentation that tells the new features by version number? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com <<...OLE_Obj...>> The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
[ADMIN] PostgreSQL Metadata
Title: PostgreSQL Metadata In Oracle, you can "select * from dictionary" to see the data dictionary table names and descriptions. Is there something similar in PostgreSQL? Also, in Oracle you can store comments on tables and columns which provides valuable metadata. Is this also possible in PostgreSQL? Here is an example create table statement in Oracle with comments: CREATE TABLE lock_date ( lock_id NUMBER(9) NOT NULL, ) TABLESPACE data / -- Comments for LOCK_DATE COMMENT ON TABLE lock_date IS 'Locks out data that arrives after Billing and Reporting periods.' / -- Column Comments for LOCK_DATE COMMENT ON COLUMN lock_date.lock_id IS 'Surrogate Primary Key for the LOCK_DATE table.' / Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com <<...OLE_Obj...>> The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
Re: [ADMIN] PostgreSQL Metadata
Title: PostgreSQL Metadata Great, thank you both for your replies. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: David Wagoner Sent: Thursday, October 30, 2003 1:30 PMTo: PGSQL List (E-mail)Subject: [ADMIN] PostgreSQL Metadata In Oracle, you can "select * from dictionary" to see the data dictionary table names and descriptions. Is there something similar in PostgreSQL? Also, in Oracle you can store comments on tables and columns which provides valuable metadata. Is this also possible in PostgreSQL? Here is an example create table statement in Oracle with comments: CREATE TABLE lock_date ( lock_id NUMBER(9) NOT NULL, ) TABLESPACE data / -- Comments for LOCK_DATE COMMENT ON TABLE lock_date IS 'Locks out data that arrives after Billing and Reporting periods.' / -- Column Comments for LOCK_DATE COMMENT ON COLUMN lock_date.lock_id IS 'Surrogate Primary Key for the LOCK_DATE table.' / Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com <<...OLE_Obj...>> The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you.
[ADMIN] User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf
Title: User Login Authentication from Multiple IP Addresses (DHCP)? pg_hba.conf I've been reading the docs and FAQs for a method to setup pg_hba.conf to allow named users to connect using MD5/password authentication from any IP address. For example, I have a Developer who would login using a client app. on his laptop which uses DHCP. Surely there is a common solution :-). I'm using PostgreSQL 7.4.1. TIA Best regards, David B. Wagoner Database Administrator
[ADMIN] Log to Syslog or rotatelogs? Advice Please
Postgres 7.3.9 on RH Linux... Setting up new production server- Is it better to send the postmaster log to Syslog or to rotatelogs? TIA, david ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] Re-initialize pg_hba.conf file?
Is there a way to have Postgres re-read the pg_hba.conf file while the database is up and running (i.e., no restarting)? Perhaps using SIGHUP? I added a user entry to the pg_hba.conf file and cannot bounce the database. thanks, david ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] Re-initialize pg_hba.conf file?
Ah, my Sys. Admin. tells me this is the easiest way and it won't restart the database instance: kill -HUP postmaster_pid -david On Wed, 16 Mar 2005 15:40:35 +0100, Miroslav Åulc <[EMAIL PROTECTED]> wrote: > David Wagoner wrote: > > >Is there a way to have Postgres re-read the pg_hba.conf file while the > >database is up and running (i.e., no restarting)? Perhaps using > >SIGHUP? > > > > > I think you're right with the SIGHUP. In my init script from Gentoo > there is option to reload (which I think is the same): > su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s" > > >I added a user entry to the pg_hba.conf file and cannot bounce the database. > > > >thanks, > > > >david > > > Miroslav > > > ---(end of broadcast)--- TIP 8: explain analyze is your friend
