others. It seems that the spacing isn't considered on ordering.
That is, for practical purposes, correct.
May I suggest that you properly normalize your tables, by putting given
name and family name into separate columns.
--
Peter Eisentraut
http://developer.postgresql.
onsistent with what you get with the "sort"
command from the shell. If that doesn't help, show us the data.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usen
mechanism away from ident and toward passwords.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Freitag, 4. August 2006 17:00 schrieb Tom Lane:
> Are you sure it's bloat, and not just a reflection of the fact that it's
> touched every page of the shared buffers over its lifespan?
That seems to be the explanation.
--
Peter Eisentraut
http://developer.postgr
rt of memory bloat
on the background writer process?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Am Montag, 24. Juli 2006 14:53 schrieb Mans:
> Isnt it a crazy thing??
Yes, but with deferrable constraints and transactions blocks, it should be no
problem to manage the data.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadc
le back to a normal
size and then closely monitor what pg_autovacuum actually does.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgre
PostgreSQL Admin wrote:
> I had my database set to SQL_ASCII and switched to UTF8, but now I
> notice that I must add a slash for periods/dots ( \. vs . ) to insert
> into varchar. Is this normal?
No.
--
Peter Eisentraut
http://developer.postgresql.or
27;1 second' + timestamp '1970-01-01'
For other meanings, adjust as necessary.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropria
t; enter two identical rows into this table.
This behavior is correct according to the SQL standard, as two null values are
not considered equal.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain ana
Am Mittwoch, 10. Mai 2006 12:03 schrieb Ganesh Chaudhari:
> I am looking for postgresql-8.1.3 rpms for Suse9 and other Suse versions.
> Could anybody point me to proper links.
ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.1.3
--
Peter Eisentraut
http://developer.postgresql.org/~
Rodrigo Sakai wrote:
> But I want to know if this kind of connection (idle in
> transaction) can cause locks and deadlocks on the db?
Certainly. Make sure the application is closing the transactions
quickly.
--
Peter Eisentraut
http://developer.postgresql.org/~
e objects are now
shown. I do not expect any application to break.
> (We haven't caught up to the SQL2003 behavior yet, but I believe
> Peter Eisentraut is working on it for PG 8.2.)
I'm committing it now. Thanks for reminding me -- I had almost
forgotten about that patch. :)
Am Montag, 27. März 2006 10:56 schrieb Erwin Brandstetter:
> Would the system locale of the _server_ OS mess with the sort order? (Or
> with anything at all?)
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of bro
or other
> users?
You can check the grant options available to the user.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
a pointer to
> the answer?
You should try something like nl_NL.utf8.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an ind
locale is not what you
apparently need.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
UTF8 locale installed on the system?
You need to have it installed and you need to tell initdb to use it.
> Or does it actually have to be the system locale?
No.
> Do multiple UTF8 system locales have any effect?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~p
Joost Kraaijeveld wrote:
> How can I change that? Why did the Debian encoding change?
It's derived from the locale, so make sure all your locales are set up
correctly.
> Can I
> still use the Debian deb files or must I manually initdb PostgreSQL?
These options are not exclusi
, and then resume recovering?
Even a read-only action uses up transaction numbers and other things, so
I'd expect that to be a problem.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
similarly. So seemingly one might as well
launch a reindexing on the table after VACUUM FULL has done its thing.
Whether that should be automatic is another question but perhaps the advice
should be documented somewhere?
--
Peter Eisentraut
http://developer.postgre
PgAdmin doesn't have any special powers. If you can log in via pgAdmin,
you can also run pg_dump. If you can't get superuser privileges for
pg_dump, you also can't get them in pgAdmin.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---
blems. But obviously you're more future-proof that way.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
this language any more..
Details please.
> Do you know others solutions to call an external script?
> Is it possible with python ?
plperlu and plpythonu also work.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
Am Mittwoch, 22. Februar 2006 10:42 schrieb Moritz Bayer:
> The running of the script failed saying I have to get "readline" on my
> system working. Well, "readline" is already installed, in Version 4.3.
Install the package readline-devel.
--
Peter Eisentraut
http:
ning
> offset for the binary data that I want>
substring and other such functions are available.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, ple
David Bear wrote:
> now, when I connection to postgres from remote machines I ssh into
> the pg server, but I tunnel postgres traffic. The ident sameuser
> prevents tunneled connections from working.
That is not true. Please give more detail so we can figure out what is
really wrong.
) library needs to come after the
> other libs (is there a way to control that?).
I think what this comes down to is that we don't support static builds
very well at all. So you will have to resort to editing
Makefile.global yourself after configuring.
--
Peter Eisentraut
http://d
(http://developer.postgresql.org/~petere/pgplsh/)/
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---(
rse you have no guarantees that the UTF-8 is
valid, so the sorting routines and others may behave erratically if they find
an error.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading
Am Donnerstag, 31. März 2005 16:12 schrieb Tsirkin Evgeny:
> The question is how it will behave will this eraise an error or it will
> just not sork correctly?
That depends entirely on your operating system's C library.
--
Peter Eisentraut
http://developer.postgresql.
Ken Hill wrote:
> I have created two database named 'testdb' and 'csalgorithm'. How do I
> find these databases?
Unless you are an expert user, you probably shouldn't be trying to find
them at all. All database administration is done through the front
Am Donnerstag, 15. Dezember 2005 10:54 schrieb sandhya:
> I have install postgresql on Redhat AS 4.Now we want to migrate data from
> oracle 8i to postgresql 8.1 and want to create snapshots , materialized
> view,dblink,taking online backup,logical backup and establish replication
> between three
ly downloaded the file
postgresql-8.0-314.jdbc3.jar and saved it under a wrong name.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
I have never figured out what the FSM numbers printed by VACUUM VERBOSE really
meant. I have for example,
INFO: free space map: 101 relations, 150 pages stored; 1664 total pages
needed
What exactly does that last number mean? I have 2 pages configured for
the FSM, so if it needs 1664, w
e file size listed here:
http://www.postgresql.org/docs/8.0/static/backup.html#BACKUP-DUMP-LARGE
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Diego wrote:
> Why don´t work in 8.1?
Because it is violating the SQL standard and 8.1 is stricter in that
regard.
> ERROR: missing FROM-clause entry for table "tabpes"
So add that table to the FROM clause.
--
Peter Eisentraut
http://developer.postgr
nagement (LVM) in your operating system, or
tablespaces in PostgreSQL.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ally "yes" and you just have to be patient. :)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Am Mittwoch, 19. Oktober 2005 18:29 schrieb A.j. Langereis:
> My pgAdmin crashed
pgAdmin issues should be reported to the pgAdmin folks at www.pgadmin.org.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
oking for is ".pgpass".
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Freitag, 7. Oktober 2005 22:13 schrieb Chris Hoover:
> Silly question, but in a shell script, what is the best way to check for a
> pg_dump problem?
0 is success, nonzero is failure.
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
what "Postgre" is supposed to be, but in case you're talking
about PostgreSQL, the chapter "System Catalogs" in the documentation should
give you all the information you need.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
haracter encoding
combinations in heterogenous environments.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index sca
Am Mittwoch, 21. September 2005 10:16 schrieb Scott Eade:
> Is it necessary for me to convert the database to some other encoding
> (e.g. UNICODE) before I can store non-LATIN1 characters or does
> PostgreSQL catch these and encode them somehow?
Yes and no.
> I have actually been attempting to co
es
> 4 - Is there a support for OSF1 OS?
Yes
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
narrow down the time frame. You
can also use pg_controldata to check the time of last change to
pg_control (which is changed when the server starts).
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In ve
Guido Barosio wrote:
> Are the below lines related with a disrupted client connection and a
> bad backend behaviour?
It looks like the client went away without telling the server (perhaps a
crash).
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
Am Freitag, 5. August 2005 14:32 schrieb Marco Rademeyer:
> Can PostgreSQL do replication ?
Yes.
> If possible could guide me in the right direction.
http://www.google.com/search?q=postgresql+replication
--
Peter Eisentraut
http://developer.postgresql.org/~
Am Sonntag, 31. Juli 2005 14:15 schrieb Martin Nikolov:
> Is there a way to change the database cluster locale initialization?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched
Am Montag, 1. August 2005 07:02 schrieb ararant:
> Are there repositories to be configured for installing
> PostgreSQL with aptget?
That depends on your operating system.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of bro
interesting reasons, not related.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ms clob or blob are not used
in PostgreSQL; the limitation is the same on all column types.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
guo weidong wrote:
> FATAL: syntax error in file
> "/var/lib/postgresql/data/postgresql.conf" line 2,
> near token "/"
What you have there is not a valid postgresql.conf file at all. Please
read up on the documentation and write a valid one.
--
Peter Eisentraut
ht
re. It will be slow. But you should test yourself just how slow it
will be.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
s don't say there won't be trouble, but it'd be far less
likely.)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
s
FM wrote:
> What is strange is that users on all DB (not only DB1) are affected
> by the JBOSS .
> I understand that it locked DB1 but why it also locked users on
> others DB ?
This is fairly impossible. Please show us more concrete evidence of
what you are observing.
--
Peter Eis
:
select table1.column from table1 full outer join table2 on
(table1.column=table2.column);
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Donnerstag, 30. Juni 2005 11:58 schrieb Hannes Dorbath:
> Thanks. This works fine on Linux, but I could't get it to work on
> FreeBSD 5.3 - any ideas?
I hear that FreeBSD doesn't support Unicode, so you're probably out of luck
for now.
--
Peter Eisentraut
http://dev
was shut down, just
restore it and you should be all set.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailA
Chuming Chen wrote:
> How can I change the column definition of an existing table, ie. from
> varchar(30) to varchar(50)? Is there any way to add a new column to
> an existing table?
The ALTER TABLE command can do all that. You need version 8.0 or later
for some functionality though.
KÖPFERL Robert wrote:
> What's the better/faster alternative?
> Enabling OS-file system caching or disabling it and forcing direct
> I/O?
PostgreSQL is designed to rely on OS file-system caching, so you better
not turn that off.
--
Peter Eisentraut
http://developer.postgres
Milorad Poluga wrote:
> One (certainly not the best options) is to do something like this:
>
> pg_dump ... DB1 > PG_SCHEMA1
> pg_dump ... DB2 > PG_SCHEMA2
> diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt
What is wrong with that?
--
Peter Eisentraut
http://develope
7;t even notice that you have two machines running instead of
one. If have yet to figure that out, but it sounds quite nice.
Btw., it was probably me who told you about DRBD, but I didn't make that
up myself. A lot of people are currently using it.
--
Peter Eisentraut
http://developer.p
Am Freitag, 24. Juni 2005 11:47 schrieb Hannes Dorbath:
> can someone summarize the steps necessary to get PG8 fully setup for
> UTF-8 use, please? Locale, initDB params? Especially that SQL functions
> like UPPER, LOWER, LENGTH etc work correct as well..
Use initdb --locale=de_DE.utf8 and that sh
on
No, but you could make it much easier by posting your exact commands and the
exact screen output.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
Peter Schonefeld wrote:
> CREATE TABLE "Country"
> If i try SELECT * FROM Country, i get 'ERROR: relation "country" does
> not exist.
If you write "Country" once, then you might write "Country", not
Country, all the time, because otherwise
Tom Lane wrote:
> Although I dislike last-minute fixes, I am strongly tempted to put in
> the ignore-datallowconn-if-standalone change in all the releases we
> are about to make.
That sounds very reasonable.
--
Peter Eisentraut
http://developer.postgresql.or
ing and for that reason
the option was removed in 7.4 so you may not want to bother learning
its semantics.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Vlad Harchev wrote:
> I have a quesion - suppose I have sparc box and x86 box running same
> release of postgresql compiled with same options. Can I simply copy
> database directory between hosts (of course when postgresql server is
> stopped on both boxes)?
Absolutely not.
--
Pete
Vlad Harchev wrote:
> Is it possible for ALL database files to reside on readonly
> filesystem (provided all requests made into database are selects)?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
Am Donnerstag, 31. März 2005 16:12 schrieb Tsirkin Evgeny:
> The question is how it will behave will this eraise an error or it will
> just not sork correctly?
That depends entirely on your operating system's C library.
--
Peter Eisentraut
http://developer.postgresql.
rse you have no guarantees that the UTF-8 is
valid, so the sorting routines and others may behave erratically if they find
an error.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lis
Chris Hoover wrote:
> Also, are there any other good companies to consider for support?
http://techdocs.postgresql.org/companies.php
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze
Am Freitag, 25. Februar 2005 15:42 schrieb Sabio - PSQL:
> Can I do a cross tablespaces queries?
Sure.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free s
> unicode,
Nope, Unicode support is always enabled.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
(http://developer.postgresql.org/~petere/pgplsh/)/
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
postgres, even if it is of little value.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTEC
gly. But
note that this voids your warranty because it is not covered by the
installation instructions. :)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
software files is
wrong.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Am Dienstag, 4. Januar 2005 16:10 schrieb Sukhdeep Johar:
> My DBD:Pg install is failing since it doesn't find pg_config.
apt-get install postgresql-dev
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)-
at the file system size. That's the only way you can
be sure.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining colu
Chris Hoover wrote:
> Would someone please be so kind as to point me to a listing of field
> type sizes, and also how to calculate the space usage of the
> associated indexes.
FAQ 4.6
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Iain wrote:
(B> Is there a "standard" directory that people tend to use for this,
(B> such as /var/local/pgsql/ ?
(B
(BAccording to the Filesystem Hierarchy Standard, program data should be
(Bunder /var/lib/. Indeed, many binary distributions use
(Bsome variant of that as data directory lo
Am Dienstag, 7. Dezember 2004 03:55 schrieb [EMAIL PROTECTED]:
> I'm considering using the DRBD network block device for a Postgres high
> avilability solution. Does anyone have any experience with this kind of
> setup?
Yes, many people use this kind of setup. It works fi
-tree index, but with some rows for sure.
> We'd also like to know how does PostgreSql implement that comparation
> Between bytea fields (if it compares all the content of the field,
Yes.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
asonable and the best option in
many cases. But the original idea of replacing all other character sets
won't really happen anytime soon. Since you work in Japan, I would think you
know about the problems, since much of the technical opposition comes from
there.
--
y, but it is a failure in practice.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
account has a reasonable locale set (presumably
chosen somewhere during the system installation), everything will work
out.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our
Pallav Kalva wrote:
> How do i know which one is for installing the Postgres server and
> what are the other packages for ?
rpm -qpi packagefile
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP
Am Freitag, 15. Oktober 2004 08:37 schrieb macdickson:
> Can any one tell me how to store jpegh files in Postgres Database
Use the data type "bytea".
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)-
ow maintenance, and it works.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ween the
two. (I think the Red Hat cluster mentioned elsewhere amounts to the
first variant, more or less.)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go t
about whether your system or your jail, respectively,
needs that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comm
stig erikson wrote:
> is there some way to avoid the pg_hba.conf-file?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.
[EMAIL PROTECTED] wrote:
> Is there any chanse to restrict access to pg_database, which gives in
> result of querying pg_database only database which is owned by my
> restricted user?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Maximiliano Araujo Pedatella wrote:
> Jonh is really a superuser. Then, for this reason, cannot I revoke
> your privilege in the referred table?
You can revoke all you want, but a superuser ignores all privilege
checks.
--
Peter Eisentraut
http://developer.postgresql.org/~
ented characters appear at
their correct place, whitespace is ignored. The latter in principle applies
to all other language-specific locales as well, except that the particular
relative order of the letters may be different.
--
Peter Eisentraut
http://developer.postgr
will be different.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
; asking the table schema, so...why is this so slow?!?!? My last
> administrative action into this table was a reindex to all the indexes via
> the BKI in standalone mode. I thought I suceed, but this was las saturday.
Do you regularly vacuum and analyze the database?
--
Pet
101 - 200 of 508 matches
Mail list logo
