Hello,
it seems( for quite some time now ) that PostgreSQL is using the -c option of iconv when exporting data to a different encoding:
http://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.13/iconv.1.html
- e.g. the Euro sign is removed when exporting LATIN1 databases
Hello,
I wonder whether extra measures are necessary to recover from a disk full error
besides freeing enough disk space?
It seems that there are enough security measures:
http://archives.postgresql.org/message-id/cahhcrepqncn3hoxswaotsj3hjkp5noepb2ky3dfgva4jcxh...@mail.gmail.com
Is it no
Hello,
Am 04.01.2012 14:06, schrieb Dick Visser:
The archive lists web server seems to have been reinstalled or
something, there is no content any more, just an empty Lighty page
from old years day:
http://archives.postgresql.org/
No announcement on the Postgres homepage... is this
Hello Andreas,
Am 15.12.2011 18:40, schrieb lst_ho...@kwsoft.de:
Zitat von jan-peter.seif...@gmx.de:
Original-Nachricht
Datum: Thu, 08 Dec 2011 13:04:30 +0100
Von: lst_ho...@kwsoft.de
Zitat von Jan-Peter Seifert jan-peter.seif...@gmx.de:
I wonder whether the number
Hello Andreas,
thank you very much for the link.
Original-Nachricht
Datum: Thu, 08 Dec 2011 13:04:30 +0100
Von: lst_ho...@kwsoft.de
Zitat von Jan-Peter Seifert jan-peter.seif...@gmx.de:
I wonder whether the number of connections is still limited on
Windows 64-bit
Hello,
I wonder whether the number of connections is still limited on Windows 64-bit
if you also use a 64-bit version of PostgreSQL:
Hello,
as the topic suggests there's unfortunately a pretty effective way to
thwart the PostgreSQL installation via the One click installer for Windows.
If a different program than the Windows Scripting Host is registered as
default software for the file extension .vbs then installation fails.
Hello,
Am 15.02.2011 12:26, schrieb Achilleas Mantzios:
Στις Tuesday 15 February 2011 12:44:31 ο/η Lukasz Brodziak έγραψε:
Hello,
How can I set PostgreSQL locale and encoding to be pl_PL.cp1250 all I
can do is pl_PL.UTF-8.
I have PG 8.2.4 on Ubuntu 10.04 (polish version).
There are no code
Hello,
we have a strange problem with a server instance:
PostgreSQL 8.2.11 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.3 20070929
(prerelease) (Ubuntu 4.1.2-16ubuntu2)
It's one of several clones (server/system) where one of our applications cannot
work with a specific database restored
Hello,
Original-Nachricht
Datum: Mon, 03 Jan 2011 11:05:30 -0500
Von: Tom Lane t...@sss.pgh.pa.us
An: Jan-Peter Seifert jan-peter.seif...@gmx.de
CC: pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] Obscure problem due to high system OID or privileges?
Jan-Peter Seifert jan
Hello,
there seems to be a difference between information_schema and pg_catalog when
it comes to privileges.
pg_class and pgAdmin III show ACL = arwdDxt
pgAdmin III displays this as:
GRANT ALL ON TABLE blabla.tabelle TO benutzer;
However, information_schema.role_table_grants has is_grantable
Hello,
I thought I had some experience with plpgsql functions by now. However, when
trying to do this query (generic column/table names):
UPDATE table_a cus SET spalte1 = ( SELECT spalte1 FROM table_a_copy cl WHERE
cl.tabname = cus.tabname );
from within a plpgsql funtion I get the error
Ouch. My mistake. :(
The copy had of course duplicate data sets, because I trapped errors during its
creation and because of the missing 'WHERE 1=0'.
Sorry,
Peter
--
GMX DSL SOMMER-SPECIAL: Surf Phone Flat 16.000 für nur 19,99 ¿/mtl.!*
http://portal.gmx.net/de/go/dsl
--
Sent via
Am 28.05.2010 19:57, schrieb Dave Page:
On Fri, May 28, 2010 at 6:56 PM, Bruce Momjian br...@momjian.us wrote:
Marc G. Fournier wrote:
On Fri, 28 May 2010, Bruce Momjian wrote:
No idea. I talked to Dave Page on IM and he thought it wasn't moved.
It wasn't until I did it. There are no
Hello,
I wonder whether pginstaller is still being maintained for 8.3 and 8.2, because
there are no binaries for the current minor versions yet and because of this
comment from January 10ths newsletter:
---
In pgsql/doc/src/sgml/installation.sgml, update Windows
Hello,
LOG: database system was interrupted; last known up at 2010-03-26 11:22:36
CET
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 1F/D2454CD0
The data still seemed to be okay - all the
Hello,
how fatal is it for the server/data if a server runs out of memory?
Happened on a Windows server some time ago. A transaction got too large. In the
log it began with:
TopMemoryContext: 37171728 total in 4046 blocks; 67640 free (4060 chunks);
37104088 used
Hello,
The files belonging to this database system will be owned by
user Administrator.
This user must also own the server process.
the user here should be postgres.
Are you 'locally'/'directly' installing on the server machine?
Good luck.
Peter
--
Sent via pgsql-admin mailing
Hello Andrzej,
try this:
Identify the code page Windows is using for LATIN2 with the PostgreSQL tool
pg_controldata (8.2 server's version). Look for the number following the dot in
LC_COLLATE / LC_TYPE. For LATIN1 it's 28591.
Try creating the database for 8.4 with the PostgreSQL tool createdb
Hello,
nobody did answer so far it seems ...
In 8.2 they had no problem. In 8.3, however they now get the following
error
On several tables:
pg_restore: [archiver (db)] COPY failed: ERROR: character 0xe28899
of encoding UTF8 has no equivalent in WIN1252
CONTEXT: COPY emails, line
Hello,
Tom Lane wrote:
SELECT table_name FROM information_schema.views WHERE table_schema =
current_schema() AND table_name LIKE '\_%\_username';
does also match views with names like table_username.
Unless you have standard_conforming_strings turned on, those backslashes
are going to
Hello,
we have user specific views with names that follow this pattern:
_table_username
Strangely the following select:
SELECT table_name FROM information_schema.views WHERE table_schema =
current_schema() AND table_name LIKE '\_%\_username';
does also match views with names like
Hello,
is there a proper way to remove the PostgreSQL debugger functions etc. from a
database? It seems that the pgInstaller for Windows does/did install them by
default. So during restore they cause error messages in servers without the
debugging dll. It seems that the script pldbgapi.sql
Hello Oliveiros,
I'm glad that your server is working smoothly now.
I 've once edited the hba file, but it was to allow remote connections, I
didn't know it could be used to allow trust connections. Learned
many things from the links you sent me.
Do you still have trust enabled? Everybody
Hello Alvaro, Hello Tom,
thank you very much for your quick and helpful replies.
You can always cast pretty much anything to anything via a variable
assignment in plpgsql...
thud I only tried it in SQL. So the function works just fine after the
removal of the text cast on 8.2 as well.
For
Hello,
for dropping all functions within the current schema I use this SQL query:
SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;'
FROM pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
p.pronamespace WHERE n.nspname = current_schema();
It works
Oliveiros wrote:
To start it, I have to login as postgres and manually start it with
postgres -D etc.
You should make a backup first (users and databases ...) .
Try unregistering/registering the service with pg_ctl.
First copy the pg_ctl command used during installation from the
service's
Abraham, Danny wrote:
The same command worked fine on PG 8.2.4.
Now, using 8.3.7, we are forced into WIN1252.
In 8.2 on Windows code page 28591 has been used. If you use this as
locale initdb should give you LATIN1.
Something like this should work for you as well:
initdb
Hello,
what is the backward compatibility policy regarding the contrib modules'
uninstall scripts?
http://www.postgresql.org/docs/8.3/interactive/contrib.html
Can one be sure that all of the contrib module's functions etc. are removed
from the database if you use an uninstall-script from a
m...@bortal.de wrote:
any idea what i am doing wrong here?:
pgtwo:/usr/local/src/postgresql-8.2.13/contrib/tsearch2/gendict#
./config.sh -n de -s -p german_UTF_8 -v -C 'Snowball stemmer for German
Do you understand German?:
Hello,
regarding the logging settings I've some questions.
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html
log_rotation_age
Are log files automatically rotated at midnight per default as it seems?
Wouldn't truncate_on_rotation cause information loss otherwise? If
Hello,
Alvaro Herrera wrote:
Tom Lane wrote:
If there's some identifiable bit of the documentation that confused you
about this, please point it out so we can improve it.
... because, apparently, lots of people are bitten by the same
misunderstanding.
Maybe it's not the documentation
Hello,
Kevin Kempter wrote:
On Tuesday 10 March 2009 11:13:54 Carol Walter wrote:
I want to recreate users with their passwords from one database
cluster on another database cluster. What would be the best way for
me to do this?
from the old server run this (where new_db_cluster is the new
Hello Venkat,
After setting the archive parameter 'archive_mode' to on in
postgres.conf file, i started the posgres service. On starting the
service, getting error with message The application failed to
initialize properly (0x142). Click on OK to terminate the
application. After this
Hello raf,
Easier is just
select oid::regprocedure from pg_proc where whatever
note that this method doesn't produce a complete function
signature. the precision and scale of numerics are not
included in the output. hopefully, that won't matter for
your needs.
Oh. So functions
Hello Tom,
I combined your suggestions into this query I'll be using for now:
SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM
This is flat *wrong*, as you'll soon find if you are working with
functions in more than one schema. regprocedure already puts a
schema
Hello Ashish, Hello Tom,
thank you very much for your quick and helpful replies - I really appreciate
that.
May be this will help you:
Easier is just
select oid::regprocedure from pg_proc where whatever
I guess I'll go with the very nifty type cast suggested by Tom though as this
Hello Ashish, Hello Tom,
before I reinvent the wheel I'd like to know whether there's a shortcut
for getting the 'full' name (incl. argtypes) of the functions within a
database in order to REVOKE priviliges on them given to certain users.
I combined your suggestions into this query I'll be
Hello,
before I reinvent the wheel I'd like to know whether there's a shortcut for
getting the 'full' name (incl. argtypes) of the functions within a database in
order to REVOKE priviliges on them given to certain users.
I don't see anything in the docs:
Hello,
Tena Sakai wrote:
I just finished installing postgres 8.3.6 and was
able to start it. The log file reads:
[2009-02-22 00:27:01.824 PST] 11543 2009-02-22 00:27:01 PST LOG:
database system was interrupted; last known up at 2009-02-22 00:25:04 PST
[2009-02-22 00:27:01.825 PST]
Hello,
I have adjusted postgres parameters per your recommen-
dation. Work_mem is now 8GB,
GB is just a typo I guess? Otherwise the value is insanely high. See:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html
Peter
--
Sent via pgsql-admin mailing list
John Chase wrote:
#listen_addresses = '*' # what IP address(es) to listen
on;
umm. is the '#' still there?
Then the changes have no effect, because the line is commented out ...
Peter
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
Hello,
I've a question regarding caching of results in the PostgreSQL-Server.
As expected a:
SELECT COUNT(*) FROM table;
causes a sequential scan of the table. The table I tested this on has about 345
000 tuples. This and any following run took about 50-60 seconds on a test
system
Andreas Wenk wrote:
In pg_hba.conf we have:
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# local is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
hostall all
Hello Scott,
Date: Mon, 12 Jan 2009 13:09:19 -0700
From: Scott Marlowe scott.marl...@gmail.com
without success I tried to set the default tablespace via the
environment variable PGOPTIONS.
My tries:
set PGOPTIONS=default_tablespace='pgdata'
...
I do this one of two ways usually.
Hello,
without success I tried to set the default tablespace via the environment
variable PGOPTIONS.
My tries:
set PGOPTIONS=default_tablespace='pgdata'
set PGOPTIONS=default_tablespace='pgdata'
set PGOPTIONS=default_tablespace(pgdata)
set PGOPTIONS=default_tablespace('pgdata')
When I try to
Hello Thomas,
thank you very much for your quick reply. However, this version doesn't work
either - at least on Windows.
Peter
try
set PGOPTIONS=-c default_tablespace='pgdata'
without success I tried to set the default tablespace via the
environment variable PGOPTIONS.
My tries:
Rafael Domiciano wrote:
The database has around 40 Gb.
If I not use vacuum full everyday the database get very slow.
There is no deadlock on the database.
The vacuum does a clean in the table and in every index of the table
clifatura. And in the end of the vacuum, seems that vacuum is
Hello,
I wonder what the current status of shared memory on Windows and PostgreSQL is.
http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#SYSVIPC
says On Windows, PostgreSQL provides its own replacement implementation of
these facilities.
I didn't find any details on this.
Hello,
kevin kempter wrote:
I'm trying to run a restore from a pg_dump and I get loads of these:
invalid command \N
I see lots of \N char's in the data for some of the tables (NULL's ?)
Are you using pgAdmin's SQL-editor for restoring by any chance? It
throws errors - especially if the
Hello,
we've been reported a problem with installing PostgreSQL v8.2.9 via ICA-Client
- initdb failed with error code 128. Installation of v8.3 and strangely v8.1
was no problem.
It seems to be an older problem:
http://archives.postgresql.org/pgsql-hackers-win32/2004-08/msg00288.php
Did you
Hello Peter,
thank you very much for your quick reply.
Datum: Thu, 04 Sep 2008 16:46:33 +0300
Von: Peter Eisentraut [EMAIL PROTECTED]
An: Jan-Peter Seifert [EMAIL PROTECTED]
CC: Postgres pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] server/db encoding (mix) issues
Jan-Peter Seifert
Hello Peter,
thank you very much for your quick reply again.
Datum: Thu, 04 Sep 2008 16:43:42 +0300
Von: Peter Eisentraut [EMAIL PROTECTED]
An: Jan-Peter Seifert [EMAIL PROTECTED]
CC: Postgres pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] pg_dump etc. versions
I think the only thing
Hi,
Datum: Mon, 1 Sep 2008 11:40:29 +0530
Von: Vishal Arora [EMAIL PROTECTED]
Betreff: Re: [ADMIN] Configure DB
Date: Sat, 30 Aug 2008 11:42:57 -0500From: [EMAIL PROTECTED]:
[EMAIL PROTECTED]: [ADMIN] Configure DB
Hi List, I'm working with Postgres, I'm storing spatial information, but
Hello,
I'm wondering if there's a compatibility list of the tools supplied with
PostgreSQL - e.g. psql seems to be very server version specific (only major or
also minor versions?).
For pg_dump I'd say users should use the version of the target server if it's
already installed, but is this
Hello Andriy,
the reply-to settings are a bit uncomfortable here. Your mail went only
to me. But I'm not part of the developer or support team. It's strange
that pg_ctl doesn't say anything else. Is there any system sniffer on
FreeBSD like Process Monitor on Windows? I can only say that the docs
Hello,
I wonder what this variable in initdb is about: POSTGRES_SUPERUSERNAME
Apparently the default should be 'postgres'. However, the value changes with
the user that is logged in whenever I use 'initdb --show'. If I login as 'xy'
the value is 'xy'. Shouldn't this be a fixed value in the
Hi,
I wonder why pgAdmin's query tool can't process the COPY commands generated by
a BACKUP (pg_dump) in plain text dumps (COPY table (column1, column2) FROM
stdin). Is it just that it's from standard input? Is there a way to make it
work?
Thank you very much,
Peter
--
GMX startet
Hi there,
sorry if this is the wrong group. The problem is that the software in use is
not capable of using UTF-8 as encoding yet. So LATIN1 has been used as server
and database encoding for Linux and Windows. However, as PostgreSQL 8.3 is
enforcing matching encodings and locales it's not
59 matches
Mail list logo