Re: [ADMIN] Issue while installing RPM's

rpm -e postgresql-libs-7.4.8* error: Failed dependencies: libpq.so is needed by (installed) postgresql-server-7.4.17-1PGDG.i686 rpm -e --nodeps post... Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 5: don't forget

Re: [ADMIN] replicating postgresql database to ms-sql database

On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote: I have been asked if it is possible to asynchronously replicate a postgresql database to ms-sql. My answer is yes, provided postgresql ORM features aren't used in the design of the database. One does an ascii dump of the tables

Re: [ADMIN] "_" in a serach pattern

The only difference is that varchar can have a length limit, text is always unlimited length. There's no significant performance difference between either. For most intents and purposes, they're equal. Forgive me for diversion, but out of curiosity, would it make some difference whether string

Re: [ADMIN] merge two rows where value are null

On Tue, 14 Aug 2007, [EMAIL PROTECTED] wrote: Name, Surname , Job, Hobby, Pet, address John, Smith, NULL, photo, NULL, NULL John, Smith, student, NULL, cat, NULL by using name and surname as selecting key, I want : John, Smith, student, photo, cat, NULL If you are sure there's no con

Re: [ADMIN] adding a user with the permission to create trimmed users

I want to know whether there exist the possibility to create a user who has the permission to create users with preset limited permissions. In detail: I do not want that the admin user (a separate limited one for the customer) is able to create full admin users or adequate ones. It's likely p

Re: [ADMIN] adding a user with the permission to create trimmed users

If you're on 8.1 and upwards, createrole is not separate from superuser. But Sorry, please read "createrole is not separate" as "createrole is NOW separate". I also wanted to add that a good testing is needed. Regards, Ben K. Developer http://benix.tamu.edu ---(end o

Re: [ADMIN] HELP, can't implement e filter

On Sun, 19 Aug 2007, [EMAIL PROTECTED] wrote: Hi, I need to implement a filter in order to select from the first table the second one... c1 c2 c3 c4 c5 1)133659;1;"0039";"00121";7 2)133664;1;"0039";"00121";12 3)133664;2;"0039";"00121";12 4)133665;2;"0039";"00121";12 5)135460;1;"0039

Re: [ADMIN] How to monitor resources on Linux.

On Wed, 29 Aug 2007, John R Allgood wrote: [pcmiler] was compiled under Redhat 8.0. I thought that you might find virtualization useful. (Run redhat 8.0 as a guest OS) Sorry for the noise if you already have considered it, but it is a typical case vmware used to tout as a success story. (Runn

Re: [ADMIN] How to monitor resources on Linux.

On Wed, 29 Aug 2007, John R Allgood wrote: I wish that was the case the linux version has to be installed locally. I'm not an expert but I guess "local" may be a bit different in virtualization. If "local" requirement is from license or security issues, there are ways to completely hide th

Re: [ADMIN] privileges

Could it be the search path (schema) issue? Just a quick thought... Regards, Ben Kim On Thu, 28 Aug 2008, Carol Walter wrote: Hello, I asked this question yesterday, but perhaps I did so in an unintelligible way. I didn't get any answer that time. Someone usually answers my ques

Re: [ADMIN] Database Conversion

I have a new faculty member who has a large database that is in MySQL. We don't support MySQL so the database needs to be ported to PostgreSQL. Her GA, who know MySQL, says that he has a query that he will run that will put the data into postgres. I thought that the data would have to be outp

Re: [ADMIN] Default data directory

x=... will likely be where the "data" sits? Regards, Ben Kim -- 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] problem with pg_stat_activity view

fe80::104d:416e:a8dc:c02e %12 Since %12 is a "space" character, it seems first thing to do might be an extra space in your code. Just a quick guess. Regards, Ben Kim On Mon, 8 Sep 2008, Sofer, Yuval wrote: Hello, postgres version: 8.2.0.4 platform windows: server 2008

Re: [ADMIN] problem with pg_stat_activity view

Sorry, I apologize for the mistake. %20 is the space, and the extra %12 seems to be DC3 (device control 3). Regards, Ben Kim On Mon, 8 Sep 2008, Ben Kim wrote: fe80::104d:416e:a8dc:c02e %12 Since %12 is a "space" character, it seems first thing to do might be an extra spa

Re: [ADMIN] problem with pg_stat_activity view

That explains it... I thought it was a precent encoding but at the same time a strange place for a control character. Regards, Ben Kim On Mon, 8 Sep 2008, Alvaro Herrera wrote: ERROR: invalid input syntax for type inet: "fe80::104d:416e:a8dc:c02e%12" SQL state: 22P02 I

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

From: "Markova, Nina" <[EMAIL PROTECTED]> I also plan to try to export data in XML format (from Ingres) and import it to Postgres. I didn't find any utility for importing XML data into Postgres. You can possibly use perl's XML::Xpath for XML import (DBIx::XML_RDB for export), assuming the tab

[ADMIN] analytics

so, what tools (ETL, ad-hoc reporting, etc.) work well with Postgresql? Is there any plans or projects for Postgresql in this application? Thanks. Regards, Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University

Re: [ADMIN] analytics

Thanks to all who replied. I guess I realize odbc may work for most of the products as long as the analytics tool works with RDBMS. We'll be explore the Mondrian option as well. Regards, Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University O

Re: [ADMIN] NIC to NIC connection

etter than that of the external link. But the former is significantly better during a busy day. (But then, the database sessions are more likely to be interactive type of traffic...) You also get security as a side benefit. (Data can't be snooped.) Regards, Ben Kim Database Develop

[ADMIN] Question: drop database problem

etc.) dropdb gives the same result. ERROR: Postmaster environment variable 'PGDATA3' not set dropdb: database removal failed Thanks in advance. Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University ---

Re: [ADMIN] Question: drop database problem

PGDATA3 is not being used for new databases. I guess I need to refine the startup script if for the rest of the databases. Will I have to shut down the server and restart it (introduce PGDATA3 properly) before I can drop that particular database? Regards, Ben Kim Database Developer/Systems Admini

Re: [ADMIN] Question: drop database problem

only after all of the backends terminate normally. This is Smart Shutdown. Thanks again, you are great. Ben Kim Database Developer/Systems

[ADMIN] request for feature - mixed case name handling

' preference, it would be really great. If anyone in this list is facing a similar problem, I would like to ask for opinions on this list. Although I spoke of inconveniences, let me say I deeply appreciate the efforts of the developers. Thanks. Ben Kim Database Developer/Systems Administr

[ADMIN] relation tmp_pg_shadow already exists

ow (datdba) from '$$PATH$$/75.dat' ; I found 2 questions regarding this problem from my google search, both of them unanswered, but hope there's a way to circumvent this error, and would appreciate any help. Regards, Ben Kim Database Developer/Systems Administrator 434E Harrington

Re: [ADMIN] relation tmp_pg_shadow already exists

uestion is, is it possible with pg_dump to create a dump including users/groups, when not using pg_dumpall? Regards, Ben Kim Database Developer/Systems Administrator 434E Harrington Tower / College of Education Texas A&M University ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] Database audit / Associating a statement with connection

port=35644 where 128.91.23.43 is my web server. The web server log records all client connections and accessed pages, but I don't have a good method of associating the web client connections with the database client connections. I'd appreciate any pointers. Regards, Ben Kim Databa

Re: [ADMIN] Database audit / Associating a statement with connection

> > Is there a way to associate them so I know which statement came from which > > connection? > > Log the PID originating each message. Thanks. Ben Kim Database Developer/Systems Administrator 434E Harrington Tower / College of Education Texas A&M University -

Re: [ADMIN] Visual data model creation / maintenance tools

but I know there are many, many of ERD tools. Regards, Ben Kim Database Developer/Systems Administrator 434E Harrington Tower / College of Education Texas A&M University ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Database audit / Associating a statement with connection

>Ben Kim <[EMAIL PROTECTED]> writes: >> Is there a way to associate them so I know which statement came from which >> connection? > Log the PID originating each message. > regards, tom lane This is a follow up in addition to the log pid. It&#

Re: [ADMIN] restore database from bare files

d over from the previous line. My 2 pence... Regards, Ben Kim Developer College of Education Texas A&M University ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] restore database from bare files

>psql: FATAL: IDENT authentication failed for user "ezpublish" This might help, or you may want to check or post your pg_hba.conf. http://archives.postgresql.org/pgsql-sql/2004-03/msg00202.php (or http://www.postgresql.org/docs/7.4/interactive/auth-methods.html#AUTH-IDENT)

[ADMIN] Changing

I just wondered if there is a way to change the variable sign from : to $, like \set avar 32 select :avar ; ---> select $avar ; so I can copy and paste my perl code directly to psql when debugging, assuming I do a proper \set. TIA. Ben Kim Developer College of Education Texas A&M Uni

Re: [ADMIN] SQL Server 2000 to PostgreSQL 8.0.3

mismatches in data types, but you can convert data using scripts inisde the DTS task on the fly. Regards, Ben Kim Developer College of Education Texas A&M University ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] SQL Server 2000 to PostgreSQL 8.0.3

, > "StatusID" int4, > "TrackingNumber" varchar(50), > ponumber varchar(50), <--HERE > "Comment" char(254), > "sfOrderNumber" varchar(50), > "UpdateDate" timestamptz >) >WITH OIDS; >ALTER TABLE "Orders&q

Re: [ADMIN] SQL Help - Obtaining ID of record INSERTED

, but this works and sometimes this way is convenient for batch processing. >SELECT @@identity as orderid My 0.02$. Regards, Ben Kim Developer College of Education Texas A&M University ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] full data disk -- any chance of recovery

of broadcast)--- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > Regards, Ben Kim Developer http://benix.tamu.edu ---(e

Re: [ADMIN] strange hung processes

revent this >from happening again. If it's not sensitive information, what does this show? lsof | grep 'pid of hung process' Regards, Ben Kim Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 3: Have

[ADMIN] clarification

In my previous post, > I intentionally used the same user name for both versions, only used a > different directory. The two installations share the same PGDATA > environment variable. I want to clarify the above. I wanted to say "Although I have two versions of postgres, because I have only one

[ADMIN] upgrade question: running different versions on one host

Hi, I compiled 7.3.4 on a host already running 7.2.1, with "--prefix=/different/directory --pgport=5833 ..." option. According to the installation instructions on developer.postgresql.org/docs/postgres/install-procedure.html, I thought I only have to give a different directory as the --prefix,

[ADMIN] update question: two versions

On another trial, I couldn't reproduce the problem, so I guess I could have been mistaken about old binary overwritten by "make install". I would like any advice, though, relating to the issue. Thanks. Ben ---(end of broadcast)--- TIP 9: the planne

[ADMIN] question re double quotes

Hi, I wonder if it is possible to let psql recognize Mixed-case-named ("LikeThisName") table names without double quotes in sql statements. Thanks to the readline, the table name seems to autoexpand to the full name "LikeThisName", if I just type in "Like" and press the tab key. But when I execut

[ADMIN] question re crosstab query

Is there a plan to implement crosstab query feature? Are there ways other than using some frontend tool, COPY or pg_dump? Thanks, Ben ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/doc

Re: [ADMIN] question re double quotes

Thanks. Regards, Ben On Mon, 20 Oct 2003, Tom Lane wrote: > Ben Kim <[EMAIL PROTECTED]> writes: > > Thanks for the reply. I haven't looked at the source code yet, but > > assuming I understood it correctly, if we can simply add double quotes > > around tab-co

Re: [ADMIN] question re crosstab query

Thanks for the information. Regards, Ben On Thu, 16 Oct 2003, Adam Witney wrote: > > I think the tablefunc module in contrib will do crosstab queries > > HTH > > adam > > > > > Is there a plan to implement crosstab query feature? Are there ways > > other than using some frontend tool, CO

Re: [ADMIN] question re double quotes

L PROTECTED]> writes: > > On Wed, Oct 15, 2003 at 16:45:39 -0500, > > Ben Kim <[EMAIL PROTECTED]> wrote: > >> I wonder if it is possible to let psql recognize Mixed-case-named > >> ("LikeThisName") table names without double quotes in sql statements. >

Re: [ADMIN] per-database logging

Thanks. Is there a disadvantage of running separate postmaster compared to running one postmaster with multiple databases? Regards, Ben On Sat, 6 Mar 2004, Tom Lane wrote: > bkim <[EMAIL PROTECTED]> writes: > > Is it possible to use a dedicated log file for each database? > > Sure, if you run a

[ADMIN] Can I make PostgreSql namespace case-insensitive?

Dear List, Is there a way to completely turn off case sensitivity of the names of table, field, sequence, etc.? In our case we used mixed-case names, and the names are unique. They wouldn't collide even if they get turned into lowercase names. Because of interfacing problems with other software

[ADMIN] tweaking scan.l

u are interested. http://www.interakt.ro/products/bbs/view_0_9873.html Thanks, Ben Kim ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] sequence value of the record just inserted.

. I would appreciate an advice. Regards, Ben Kim ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] sequence value of the record just inserted.

e perl DBI, so am not sure how I can get the oid into a perl variable. I appreciate the help. Regards, Ben Kim ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] sequence value of the record just inserted / DBI

It's supposed to be metadata, and CREATE USER has CATALOG|NOCATALOG option, but what would be $catalog value for a user table in this context? Thanks in advance. Ben Kim ---(end of broadcast)--- TIP 3: if posting/reading through U

[ADMIN] parametrized query

rl $sth = $dbh -> prepare ("insert into mytable values (?, ?, ?)") Is writing a function the only way? Is there another way that can be done without writing a function? Thanks, Ben Kim ---(end of broadcast)--- TIP 6: Have yo

[ADMIN] force connection timeout

each page, but somehow this problem persists. I'd appreciate any advice. Thanks, Ben Kim ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] postgresql 8.4

I'm planning to upgrade. Is there a updated release schedule for 8.4? Thanks. Ben Kim -- 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] postgresql 8.4

l.org/index.php/PostgreSQL_8.4_Development_Plan http://www.postgresonline.com/journal/index.php?/archives/56-PostgreSQL-8.4-goodies-in-store.html Both are about a year old articles and point to 3/1/2009 release. Regards, Ben Kim On Thu, 2 Apr 2009, Tom Lane wrote: Ben Kim writes: I'm planning to

[ADMIN] linux standard layout

BI may not be a good example.) In general I didn't have any problems yet with standard rpms and I can make the rpms work if there's a problem, but I may be missing something. Any advice or reference to a relevant article on this issue will be appreciated. Thanks. Ben Kim -- Sen

Re: [ADMIN] linux standard layout

Thanks all. I cannot change the decision on vmware or layout, but it's great to know that the rpm way is a valid one. I appreciate all inputs. Regards, Ben Kim On Mon, 8 Mar 2010, Scott Marlowe wrote: On Mon, Mar 8, 2010 at 10:31 PM, Ben Kim wrote: Dear list, I have abo

[ADMIN] compare two rows

write a generic script to iterate through the list of fields and compare each field values, or concatenate the fields to a string, but wondered what is out there. Also, is there a way around to use select row(...) = row(...)? Thanks. -- Ben Kim -- Sent via pgsql-admin mailing list (pgsql-admin

Re: [ADMIN] compare two rows

* from test_dup; id |val + 1 | some text 2 | some texta How can I check whether the two rows are the same or different? Thanks. On Tue, Oct 12, 2010 at 02:12:36PM -0700, Richard Broersma wrote: > On Tue, Oct 12, 2010 at 1:17 PM, Ben Kim wrote: > > Admins,

Re: [ADMIN] compare two rows

, (select val1, val2, val3, ..., val100 from test_dup where id=2) t2 ; This gave me a blank row when all of val1 ... val100 matched, and a value of "f" when something did not match. (Wish there was a shorthand way to express "all fields (*) except id field". Is it possible?)