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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
---
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
only after
all of the backends terminate normally. This is Smart Shutdown.
Thanks again, you are great.
Ben Kim
Database Developer/Systems
' 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
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
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
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
> > 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
-
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
>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
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
>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)
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
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
,
> "StatusID" int4,
> "TrackingNumber" varchar(50),
> ponumber varchar(50), <--HERE
> "Comment" char(254),
> "sfOrderNumber" varchar(50),
> "UpdateDate" timestamptz
>)
>WITH OIDS;
>ALTER TABLE "Orders&q
, 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
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
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
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
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,
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
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
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
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
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
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.
>
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
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
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
.
I would appreciate an advice.
Regards,
Ben Kim
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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
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
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
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
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
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
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
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
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
* 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,
,
(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?)
60 matches
Mail list logo