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 possi
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 ShortView
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 clust
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
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 also
Hello,
we have a mix of older software still using LATIN1 as db encoding and the
psqlODBC-drivers (ANSI) and newer software using UTF8 as db encoding. As
running two server instances would use up more resources(?) than just one we'd
like to have all dbs in one cluster. Which cons against this s
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
w
> Datum: Thu, 04 Sep 2008 22:01:51 -0400
> Von: Andriy Bakay <[EMAIL PROTECTED]>
> An: Jan-Peter Seifert <[EMAIL PROTECTED]>
> CC: pgsql-admin@postgresql.org, [EMAIL PROTECTED]
> Betreff: Re: [ADMIN] SSL problems
> After I disable SSL option in postgres
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
> Betreff: Re: [ADMIN] server/db encoding (mix) issues
> Jan-Pete
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
> Betreff: Re: [ADMIN] pg_dump etc. versions
> I think
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 cha
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 i
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. J
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 vacu
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.
> >
> > M
Hello Scott,
> Date: Mon, 12 Jan 2009 13:09:19 -0700
> From: "Scott Marlowe"
> > 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. Either I s
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,
I've a question regarding caching of results in the PostgreSQL-Server.
As expected a:
SELECT COUNT(*) FROM ;
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 (pgAdminIII 1.8.
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 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 (pgsql-ad
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.8
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:
http://www.postgresql.org/docs/8.3/inter
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
I guess I'll go with the very nifty type cast suggested by Tom though as this
cove
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 b
Hello raf,
> > > Easier is just
> > > select oid::regprocedure from pg_proc where
> 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 expe
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
> sch
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 th
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 is the new serv
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 documenta
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 the
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?:
http://www.tauceti.net/roller/cetixx/entry/volltextsuche_mit_pos
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 new
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 --locale=German_Ger
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 f
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 pro
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...
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 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? Everybod
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 does
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 table_userna
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
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 em
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,
> 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 mai
pgsql-admin-ow...@postgresql.org
> [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Jan-Peter Seifert
> Sent: Sunday, April 11, 2010 3:18 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] initdb failure
>
> Hello,
>
>> The files belonging to this data
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
TopTransactionC
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 ok
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 installa
Am 28.05.2010 19:57, schrieb Dave Page:
> On Fri, May 28, 2010 at 6:56 PM, Bruce Momjian 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 8.4 MSI i
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 messa
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 pgsql-ad
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,
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
> An: "Jan-Peter Seifert"
> CC: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] Obscure problem due to high system OID or privileges?
> "Jan-Peter Seifert&qu
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 a
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.
Wi
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:
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_cap
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 :
> > I wonder whether the number of connections is still limited on
> > Windows 64-bit
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 :
>
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,
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 probl
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 databas
Gesendet: Sonntag, 21. Juli 2013 um 16:03 Uhr
Von: "Peter Eisentraut"
> On Mon, 2013-07-15 at 16:55 +0200, Jan-Peter Seifert wrote:
> > it seems ( for quite some time now ) that PostgreSQL is using the -c
> > option of iconv when exporting data to a different encodin
63 matches
Mail list logo
