Hi,
this is from HEAD of a few days ago, it looks suspicious to me.
8.2devel runs on port 5433.
[EMAIL PROTECTED]:~/pgsql$ bin/psql -p 5433 template1 markus
Welcome to psql 8.2devel, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL command
2006/3/11, Michael Fuhr <[EMAIL PROTECTED]>:
> Do you have the PGPORT environment variable set to 5432?
No.
Markus
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EM
tings appropriate?
Why does the index on the primary key grow?
Thanks
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Ð ÐÑÐ, 07.11.2003, Ð 16:45, Tom Lane ÐÐÑÐÑ:
> Markus Bertheau <[EMAIL PROTECTED]> writes:
> > It has a unique index on virtual_domain. Every day we do <1 queries
> > of the form
> > insert into virtual_domains values (default, 'www.something.de')
>
Ð ÐÑÐ, 07.11.2003, Ð 21:45, Markus Bertheau ÑÐÐ:
> Ð ÐÑÐ, 07.11.2003, Ð 16:45, Tom Lane ÐÐÑÐÑ:
> > Markus Bertheau <[EMAIL PROTECTED]> writes:
> > > It has a unique index on virtual_domain. Every day we do <1 queries
> > > of the form
> > >
Is there similar support planned for
PostgreSQL?
Thanks.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
been used and therefore compiled successfully during a test run of an
application.
Is something like this planned or already available, but hidden well?
Thanks
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don'
oes that help when functions call other functions? The second function
will be nowhere in the logs, right?
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
tatistics collector couldn't do that job. It's an interesting number.
Is something like that planned in PostgreSQL?
Thanks
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: you can get off all lists at once wi
o to a UNICODE because this garbage
> chars are invalid in client's encoding , so they are reject (in
> translation process as invalid unicode chars).
You can dump the data, convert it with for example iconv and then load
the data again.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
e in? What encoding is the 8.0 database
in? Did you set client_encoding? What's the error message?
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
things I need to look at to sort this. Thank got
> it's Sunday.
Switch on logging by following the instructions in
http://www.redhat.com/archives/fedora-test-list/2004-March/msg01110.html
and look in the log file for the error message.
--
Markus Bertheau <[EMAIL PROTECTED]>
---
an tell bits from bytes a quick
understanding of how the UTF-8 encoding works.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
default. You can store UTF8 data in it without
> any problem, you just won't have the niceties like detection of bad
> character sequences.
This is, by the way, a reason why this encoding should be renamed to
SQL_8BIT (or something along these lines) and UNICODE to UTF-8.
--
Markus Ber
ueries!
>
> So for these reasons I need to find a way to tell JBuilder (through
> JDBC) that the ID columns are not nullable. But how? Can someone please
> help me?
>
> Thanks,
>
> Brad
>
> ---(end of broadcast)---
> TI
2008/1/28, A.Burbello <[EMAIL PROTECTED]>:
> Hi people,
>
> I would like to some suggestion to search person name
> in a table that has more than 150 milions of rows ...
>
> e.g ... name like 'JOHN%SMITH';
>
> I know there is contrib Tsearch, but I can't for
> political reasons.
> Is there any way
2008/2/6, Tom Lane <[EMAIL PROTECTED]>:
> I'm really not seeing the case for user-level documentation of HOT,
> when for instance most of the planner's optimization behavior is not
> so documented.
Actually that would be very useful information. Questions like how is
cost calculated, how are join
2008/2/13, Tena Sakai <[EMAIL PROTECTED]>:
> b) keep the 8.2.4 up and running, but via pg_hab.conf
> make sure nobody can use the database.
That's basically up to you, you can leave it open. The backup will be
consistent, but it won't contain any changes made to the database
after pg_dumpall
r can install and run PostgreSQL without extra
permissions.
Markus
--
Markus Bertheau
Blog: http://www.bluetwanger.de/blog/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Sat, 2002-01-26 at 13:30, Antony Stace wrote:
>
> Hi Folks
>
> I want to log all of the inserts and delete that occur in a postgres database.
>Whats the easiest way to do this?
tweak your postgresql.conf
Markus Bertheau
---(e
>
> /var/log/postgresql
>
> Anything else I need to do?
add
debug_print_query = true
Markus Bertheau
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
imeout = 1
wal_buffers = 64 # min 4
wal_files = 4 # range 0-64
log_connections = true
log_timestamp = true
log_pid = true
debug_print_query = true
debug_print_rewritten = false
show_executor_stats = false
show_query_stats = false
what is different?
btw: I presume we talk about 7.1.x
Markus Bertheau
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Good day,
why's that?
(user is postgres, who owns /var/lib/pgsql/data/)
bash-2.05$ bin/pg_upgrade -D /var/lib/pgsql/data/ -1
You must run pg_upgrade in either mode 1 or mode 2.
Usage: pg_upgrade [-D datadir] -1 | -2
bash-2.05$
Markus Bertheau
signature.asc
Description: This
I ran initdb in the right locale:
$ pg_controldata /var/lib/postgresql/data/ | grep LC
LC_COLLATE: ru_RU.UTF-8
LC_CTYPE: ru_RU.UTF-8
Why does it not work?
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---
-
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
How do I get rid of these huge files and how do I prevent them from
being created again? The dump of the whole database is ~50 Megabytes
gzipped.
Thanks
--
Markus
-
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
How do I get rid of these huge files and how do I prevent them from
being created again? The dump of the whole database is ~50 Megabytes
gzipped.
Thanks
--
Markus
convert the data from latin1 to
utf-8 encoded unicode on the fly. Then again I don't know what charset
denmark uses usually, probably some other latin variant.
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 2: you ca
t using the text
format (i.e. not the custom format), put the encoding thing in front of
the file and load it into your unicode database.
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 6: Have you searched our li
ngle file?
I'm sorry, someone else will have to follow up on blobs, I have never
used them :/
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
29 matches
Mail list logo
