aces I usually use for basic data control.
And my JSP webapp is choking on the French accents. I have yet to try
OpenOffice which is now the secondary data manipulation tool used by the
client after the JSP app. After a long Google I have come here to ask of
you some pointers =:-D
Cheers
Tony
Le lundi 19 décembre 2005 à 12:51 +0100, Dick Visser a écrit :
> > Can I change the encoding to UTF-8 easily?
>
> I had to convert as well while upgrading to 8.1.0.
WOW! that is a real howto. It belongs on the Postgresql techdocs site.
I'll try it and let you know how it goe
Le lundi 19 décembre 2005 à 09:20 +0100, Hannes Dorbath a écrit :
> On 18.12.2005 18:49, tony wrote:
> > createdb xxx -E LATIN1 <- old version had this encoding (intranet server
> > dates from 2000 upgrade to 7.2 done in 2002)
> > psql -d -U postgres -f .out.1 <
also remember I was obliged to do some voodoo magic on catalina to get it to
serve
the right charset. I haven't touched this system since January 2002 so it is
kind of
hard to remember the tricks I used with encoding between PostgreSQL, JDBC and
Tomcat.
Cheers
Tony
--
Tony Grant
only modifications in the new page are use of style sheets
for layout instead of tables...
I have run the query from the JSP in pgaccess and it works just fine.
Tomcat was also updated from 4 to 5.5 and I have the latest
postgresql.jar for JDK1.5
Any thoughts?
Cheers
Tony
--
Tony
Le mardi 20 décembre 2005 à 13:20 +0300, Boguk Maxim a écrit :
> Try add that into postgresql.conf:
>
> add_missing_from = on
Thanks that did the trick but it does not explain why the same query
works on the other page... =;-D
Tony
--
Tony Grant
www.tgds.net - vente d'ordinateu
changes.
ssh -v -L 5432:localhost:5432 [EMAIL PROTECTED]
Then connect to your database on localhost.
Cheers
Tony
--
Tony Grant
www.tgds.net - vente d'ordinateurs mini-itx en ligne
www.tgds.net/epiaix1.html - A fedora Core 4 based live CD for VIA Epia-M
wish (for example you are running a
postgresql server on your local machine too).
Cheers
Tony
--
Tony Grant
www.tgds.net - vente d'ordinateurs mini-itx en ligne
www.tgds.net/epiaix1.html - A fedora Core 4 based live CD for VIA Epia-M
---(end of broadcast)---
TIP 6: explain analyze is your friend
MM_keepURL.indexOf('&' + nextItem + '=') == -1) {
MM_keepForm = MM_keepForm + '&' + nextItem + '=' +
java.net.URLEncoder.encode(request.getParameter(nextItem));
}
}
}
If I convert my database to UTF-8 will this problem go away? It is
curre
Hello,
Is it possible to import a 8.1.1 dump file (standard format) into a
7.3.9 database?
I have an intranet with the most recent version and a public serveur
with selected data which is still running 7.3.
I am seeing an error with "\N"
Cheers
Tony
#x27;m thinking up a better plan.
Cheers
Tony
---(end of broadcast)---
TIP 6: explain analyze is your friend
re missing...
Back to the drawing board
Tony
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
script that only dumps out the
tables required by the public web app. And I think that I will migrate
the public server to 8.1.x if I find the RPMs for RHEL3
Cheers
Tony
---(end of broadcast)---
TIP 6: explain analyze is your friend
blic server.
ssh -v -L 5433:localhost:5432 my.intranet.url
Then pg_dump --port=5433 dbname > /var/lib/pgsql/data/db.out
I'll wait until they've finished work...
Tony
---(end of broadcast)---
TIP 3: Have you checked our extensive F
last 6 years (pg version 7).
Tony
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
tabase and tables and copy back in from text file.
What really puzzles me is the partial restore. If it is broke it should
be broke everywhere...
Tony
---(end of broadcast)---
TIP 6: explain analyze is your friend
a terminal the sql colour coding gives me a clue:
- the data contains non escaped ' as in "d'Anjou"
Is this my issue?
Tony
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Le mardi 02 mai 2006 à 10:26 -0400, John DeSoi a écrit :
> On May 2, 2006, at 10:07 AM, tony wrote:
>
> > Reading through in a text editor (nedit) rather than with pico or nano
> > in a terminal the sql colour coding gives me a clue:
> >
> > - the data contain
Le mardi 03 février 2009 à 08:41 -0500, Shrirang Chitnis a écrit :
> Funny, but I never noticed the signature until someone brought it to notice.
SH please don't bring up Larry Wall, then we are in big trouble
=:-D
Tony
--
Sent via pgsql-admin mailing list (pgsql-admin@postgr
I know that there are standard ways to graph relational databases.
It occured to me that perhaps programs existed which simply parsed the
table definitions and plotted the graphs for you.
Anyone know of such a thing?
Thanks.
-Tony
---(end of broadcast
between
multiple servers? (I was looking at a commercial vendor who had a
product that took rarely used data in Oracle databases and migrated
them to another server to keep frequently accessed data more readily
available.)
Thanks.
-Tony
---(end of broadcast
7; page
(http://www.postgresql.org/users-lounge/limitations.html) still says
that tables are limited to 16 TB, not 32 TB.
Perhaps it should be updated?
-Tony
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
milar storage concerns? I'd be interested in
knowing if I just have really poorly designed tables, or if something
else is going on here. I figure a bloat of 3-4X would be permissible
(and possibly expected). But this bloat just seems too much.
Thanks.
-Tony
---(end of broadcas
I thought I'd make a followup to the question of storage bloat. I
tried approaching the problem by living a little loosely with database
normalization and use arrays instead of flattening everything out in
the tables.
So my original table,
CREATE TABLE original (
dbIndex integer,
index1 smallint,
tart
(permissions/existence/etc).
-Tony
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
required or not. Is there any libpq
function to query the server if a password is required? Perhaps,
there's a return value for PQconnectdb which would tell me that the
connection failed because of the password? (In which case, I can ask
for the password and try the connection ag
he driver supprt and how stable is for linux.
> Any ideas?
>
I've used 3ware stuff in the past for PG on RH Linux.
http://www.3ware.com
-Tony
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unreg
solutions (did I say i don't like PHP? =:-D)
so SSO may be a challenge
TIA for your thoughts
Tony
--
---(end of broadcast)---
TIP 6: explain analyze is your friend
Le mercredi 07 février 2007 à 08:50 -0800, Joshua D. Drake a écrit :
> > Of course a CMS that is database
> > agnostic would be the ideal sollution...
>
> Drupal?
Yes of course but, well, not so serious a CMS =:-D
Tony
--
--
nother table table_B would use table_B.prefix=
table_A.prefix.so how can I create the index?
yours, Tony
2009/2/25 Michael Monnerie
> On Mittwoch 25 Februar 2009 Tony Liao wrote:
> > hi all,
> > I have a table table_A (id serial,prefix varchar),for example.
> > now I want to get the id of "johnsmith"'s prefix match
> > table_A.prefix,so I do sel
index of gist_prefix_range_ops,not found! I can insert the
column prefix with type prefix_range.
ps : doest it work in C local,or uft8?
2009/2/26 Harald Fuchs
> In article <8f750b7c0902250259w6065515as350aca3b5d7d8...@mail.gmail.com>,
> Tony Liao writes:
>
> >
hi Harald,
I reboot the machine and create index,it works.thanks.
2009/2/26 Harald Fuchs
> In article <8f750b7c0902250259w6065515as350aca3b5d7d8...@mail.gmail.com>,
> Tony Liao writes:
>
> > hi all,
> > I have a table table_A (id serial,prefix varchar),f
hi,all
for example tableA
create table tableA (
id serial,
a integer,
b integer,
c integer
);
insert into tableA (a,b,c) values (12,34,56);
then,
select id from tableA where (a||b||c)=123456;
in postgresql version 8.2.11,it works.
thanks,Julius.
2009/2/26 Julius Tuskenis
> Hi Tony,
>
> Its not a bug - automatic casting was removed in 8.3. You should cast( a as
> text)||cast(b ... = cast(123456 as text). Other option is to define your own
> operators which is to be used only in case you can not fix
hello,everybody
I want to create index for column ip1 and ip2.I know there is a
contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range.
The query would do select ... where ip1>>='96.168.65.84' or
ip2>>='96.168.65.84'.
does anyone have ideas?
hi,lee
CIDR is only accept ipv4 but not ip range such as 192.168.1.0/24.
INET type is what I need,but I don't know how to create index.
does anyone have ideas?
2009/2/27 Lee Azzarello
> On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao wrote:
> > h
I should adjust system performance,but how? anyone can help me?
thanks.
Tony Liao
Hi,
I'm trying to find out why my cluster won't start. It looks like I'm
pushing up max_connections too high although I think my memory and
semaphore settings are OK. Thing is, when the cluster fails to start I
can't see any errors in pg_log or in /var/log/messages.
When the cluster is up an
Tom Lane wrote:
Tony Webb writes:
I'm trying to find out why my cluster won't start. It looks like I'm
pushing up max_connections too high although I think my memory and
semaphore settings are OK. Thing is, when the cluster fails to start I
can't see any errors in p
Thanks Val. Yes, I checked the /var/log/postgresql directory but no joy.
Good idea re the init.d script although I may resort to pg_ctl as I dont
want to restart all of the clusters on this box.
Cheers
Pif
--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited
hi,all
I have installed prefix contrib,it works well.
now I want to insert default value [] to prefix column,because if the
prefix column is NULL,the returns are not I want (with prefix @>'text').I
alter column prefix default [],it return error:
ERROR: syntax error at or near "["
LINE 2:
Dimitri,thank you.it works well.
yours,tony
2009/4/6 Dimitri Fontaine
> Hi,
>
> On Friday 03 April 2009 05:03:37 Tony Liao wrote:
> > now I want to insert default value [] to prefix column,because if
&
Hi,All,
I have a question in libpq.the postgresql dadabase about 32MB(base on
backup),and I tried to analyze query as :EXPLAIN ANALYZE SELECT
.where id=123 ,got the total actual time is 2.882ms.
Now,I start a test programe base on ../src/test/examples/testlibpq.c
,which has 900 co
ions and use
> a pooling service instead, then run your tests again.
>
>
>
>
>
>
>
> *De:* pgsql-admin-ow...@postgresql.org [mailto:
> pgsql-admin-ow...@postgresql.org] *En nombre de *Tony Liao
> *Enviado el:* miércoles, 13 de mayo de 2009 22:39
> *Para:* pgsql
...
any Idea? thanks
--
Tony Liao
pplication,and it is not sure how many product_id
in condition,maybe the next query would be .product_id in
(4,26,7,8,9,23,27,54)
Maybe,temp table is a solution,but that would be performance issue.
thanks
2009/6/19 Scott Marlowe
> On Fri, Jun 19, 2009 at 3:50 AM, Tony
he WAL?
Thanks for any help.
Tony Nelson
Starpoint Solutions
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello,
He had a drive fail in an array and the spare kicked in to replace the
failed drive. However, when I query a specific table, I get the below
error:
ERROR: could not open file
"pg_tblspc/16412/PG_9.0_201008051/16419/5875980.7" (target block
2968776487): No such file or directory
When I c
tablespace?
On Thu, 2011-03-31 at 08:38 -0400, Tony Capobianco wrote:
> Hello,
> He had a drive fail in an array and the spare kicked in to replace the
> failed drive. However, when I query a specific table, I get the below
> error:
>
> ERROR: could not open file
> "pg_tbl
grant statement
again. How can I avoid having to issue the grant each time I create a
new table?
Thanks.
Tony
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
as anyone implemented a nagios monitor for these processes?
Thanks in advance for any help.
Tony Nelson
Since 1982, Starpoint Solutions has been a trusted source of human capital and
solutions. We are committed to our clients, employees, environment, community
and social concerns. We f
he start/stop
script and maintain that over package updates?
Ubuntu 12.04
postgresql 9.2.0.4
x86_64
2 CPUs
Thanks
Tony Dare
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
1414 ?S 0:00 postgres: reina db01 xxx.xxx.xxx.xxx idle
Is there a way that I can parse out the user names 'reina' and 'abs'?
Perhaps a sed command?
-Tony
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
is, you could come up with
something tailored to your needs in no time.
-Tony
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
containing
your database and c:\directory_where_the_db_exists is the directory
containing the data.
pg_hba.conf is the file that allows you to change which
users/computers can access the database. It's where you can set up
security in your connections. You should be able to edit it with
I seem to remember a psql option that dumped out the table schema. I
can't seem to find it in the man for psql. Could someone point out the
option to me?
Thanks.
-Tony
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
[EMAIL PROTECTED] (Lee Harr) wrote in message
news:<9ubpl9$196u$[EMAIL PROTECTED]>...
> On 30 Nov 2001 10:52:26 -0800, Tony Reina <[EMAIL PROTECTED]> wrote:
> > I seem to remember a psql option that dumped out the table schema. I
> > can't seem to find it in the m
_type" character varying(20) DEFAULT 'unknown' NOT
NULL,
"client_id" integer NOT NULL,
[...]
UNIQUE ("stock", "inventory_type", "client_id")
Constraint "inventory_pkey"
Primary Key ("sto
>
> #max_connections = 32 # 1-1024
>
> #port = 5432
> #hostname_lookup = false
> #show_source_port = false
>
> #unix_socket_directory = ''
> #unix_socket_group = ''
> #unix_socket_permissions = 0777
>
> #virtual_host = ''
&
ch as "SELECT DISTINCT subject FROM center_out"
seem to take 2-3 times longer in the new schema. Does this make sense?
I was hoping that the inherited information would lead to an
easier-to-follow, smaller, and faster database since there wouldn't be
redundant information across ta
I'm reading the list through Google groups, but I haven't seen much
activity on admin, hackers, sql, etc. over the last few weeks. Are
there just not any posts or is something screwy with Google groups
newsserver?
I was hoping to see the status of 7.2.
-Tony
[EMAIL
tep
to maintaining the database as PostgreSQL doesn't re-use
deleted/updated tuples. In order to keep the db queries fast within
PostgreSQL, you'll need to regularily perform a "vacuum analyze". The
frequency will depend on how often the database has
updated/deleted/inserted t
(
cell_nameint4 AKA file_name
);
Note that I don't think this would be true referential integrity
because 'file_name' is nowhere in the first database (it's between
them).
Thanks.
-Tony
---(end of broadcast)--
shrinks the on disk size by removing out-dated tuples.
Does the new version do this eventually?
Thanks.
-Tony
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
therefore tell me where I should
start to look for the appropriate header file to allow max name lengths
for the esql precompiler to be extended.
Hope this is the correct mailing list for this question.
Many thanks,
--
Tony
-----
Dr. Tony Griffiths
Research Fel
sort of DVD writing system would be good for accessing one or two
files in the backup quickly. It would probably also complete backups
faster. However, I think DVD's only hold a few Gigs on them. Are there
systems like with these features that could handle say 20 Gigs per
media?
Tha
e I'm
paranoid that the lab will burn down or something silly like that ;>)
I've been looking at the Exabyte systems which hold 80G/160G and write at
about 10G/hour. Anyone have experience with these? How onerous is it to
look at the table of contents or restore a specific file from t
Thanks everyone. I think I'll go with one of the tape solutions (DLT,
Exabyte VXA-2, or AIT) after all. If I can get the 80G native/160 Gig
compressed, then I can probably get buy with one or two tapes. That
should make my single-file restores a little less onerous.
-Tony
[EMAIL PROT
I just upgraded my redhat linux from 7.2 to 8.0. During that process
postgresql 7.2.2 was installed on the system. According to the
documentation i should run postgresql-dump. However, I can't find that
program anywhere. Aside from the obvious of uninstalling 7.2, what can I do?
Thanks
--
n: pg_dump ?
C.
Tony Ziolkowski wrote, On 12/29/2002 9:06 PM:
I just upgraded my redhat linux from 7.2 to 8.0. During that process
postgresql 7.2.2 was installed on the system. According to the
documentation i should run postgresql-dump. However, I can't find that
program anywhere.
SO what's the solution? I have an unworking postgresql.
-Original Message-
From: Lamar Owen [mailto:[EMAIL PROTECTED]]
Sent: December 31, 2002 8:25 PM
To: Tony Ziolkowski; [EMAIL PROTECTED]
Subject: Re: [ADMIN] postsgresql-dump not found in install
On Monday 30 December 2002 09:41,
Is there a way to recover from the following error:
NOTICE: RelationBuildDesc: can't open pg_statistic: No such file or
directory
I can't seem to find any documentation on this error.
Thanks,
TRH
---(end of broadcast)---
TIP 5: Have you checke
"change_number" column to hold the unique value.
I would like someone
to be able to submit a query like this:
update people set
name='tony', address='12345 A St', city='Downey', state='Ca', zip='92372',
phone='864-0618' wher
se can somebody help if you know how to fix this.
Thx
Tony
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
let alone the storate limit of 2GB per
> table. So sadly, PG would have to bow out of this IMHO unless someone
> else nukes me on this!
>
I just checked the PostgreSQL website and it says that tables are limited to
16 TB not 2 GB.
-Tony
---(end of
- Original Message -
From: "Bradley Kieser" <[EMAIL PROTECTED]>
To: "Tony Reina" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 01, 2004 8:53 PM
Subject: Re: [ADMIN] Do Petabyte storage solutions exist?
let alone the storate
rk
price for most of the commercial DB stuff out there? It would be interesting
to see just how expensive (cost of licensing-wise) commercial DBs really are
from a side-by-side matchup.
-Tony
---(end of broadcast)---
TIP 3: if posting/reading through
Yep. That's after a 'vacuum verbose analyze'.
-Tony
- Original Message -
From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
To: "Tony Reina" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 08, 2004 11:57 AM
Subject: Re: [
ot;Database Design for Mere Mortals" as I write).
-Tony
CREATE SEQUENCE FileIndicies_fileID_seq;
CREATE TABLE FileIndicies (
fileID integer DEFAULT nextval('FileIndicies_fileID_seq') UNIQUE NOT
NULL, --PK
szFileName text NOT NULL,
szFileType text,
CreationDate
ld to the table.
Is there any further normalization that I'm missing?
-Tony
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
At least thanks to Stephan I've narrowed my search down to one table
and I have a ballpark theoretical bloat to shoot for (6 .67X). I'm going to
go back and try to determine if I'm correctly interpretting the part of the
flat file that holds this table's data.
-Tony
--
e error
message, then the code gets broke. I doubt that's likely however.
-Tony
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Tony Reina" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 28, 2004 12:12 AM
Sub
http://gborg.postgresql.org/project/pgdiff/projdisplay.php
pgdiff should compare two PostgreSQL
databases.
-Ton
84 matches
Mail list logo
