On 7/22/13 5:06 AM, Jan-Peter Seifert wrote:
> 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
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
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 encoding:
> http://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.13/ico
databases to UTF8.
I'm not sure, but in the past it was different and those characters caused error messages instead.
So I wonder since when incompatible characters are removed?
Could someone tell me, please?
Thank you very much!
Peter
On Sun, 2013-07-07 at 10:11 +0200, Thorsten Kampe wrote:
> is it possible to start psql in interactive mode without connecting to
> a database (similar to "sqlplus /nolog" for Oracle databases)?
No, that's not possible.
--
Sent via pgsql-admin mailing list ([email protected])
To make
On 6/6/13 8:01 PM, Kasia Tuszynska wrote:
> dpkg: error processing
> /var/cache/apt/archives/postgresql-9.0_9.0.13-1.pgdg10.4+1_amd64.deb
> (--unpack):
> trying to overwrite '/usr/share/locale/zh_TW/LC_MESSAGES/plpython-9.0.mo',
> which is also in package postgresql-plpython-9.0 0:9.0.5-1~lucid
On Fri, Jun 14, 2013 at 11:55 AM, Andreas wrote:
> How can I get more memory for PG on openSUSE 12.3 ?
http://www.postgresql.org/docs/9.2/static/kernel-resources.html
--
Regards,
Peter Geoghegan
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to y
Here is a crontab example. I always specify the absolute path.
0 0 * * * /postgresql/home/scripts/backup/backup_wal_enabled_instance.sh
inst1 5432
Peter Krawetzky
-Original Message-
From: [email protected]
[mailto:[email protected]] On Behalf Of
Running 8.4.7 on Linux
Starting yesterday we began seeing a read error on the archive_status files.
Here is an example:
zip warning: could not open for reading:
postgresql/data/crppgsq1/pg_xlog/archive_status/000100050045.done
Not sure why all of a sudden we are hav
Hi,
I have installed Postgresql using One click installer on a Windows Server.
How can I check whether GSSAPI support is enabled so I can use SSPI for Windows
Authentication?
Thanks.
installer downloaded
from http://www.postgresql.org/download/windows to install PostgreSQL and I'm
not sure how to include GSSAPI support.
From: Craig Ringer [mailto:[email protected]]
Sent: Tuesday, June 12, 2012 1:11 AM
To: Peter Cheung
Cc: '[email protected]'
Subject: Re:
Hi,
I'm new to PostgreSQL. I installed PostgreSQL on a Windows Server 2008 R2
server. I have created a database and an user in Windows Active Directory.
How can I configure that user to access that database?
Thanks.
problem if the WAL is within the same disk space and can't be written
as well?
I didn't see anything in the FAQ:
http://wiki.postgresql.org/wiki/FAQ
Should you free enough disk space, do a checkpoint, restart the server and
check the server log?
Thank you very much,
Peter
--
Emp
On tor, 2012-04-19 at 10:02 +0200, Albe Laurenz wrote:
> After looking at the UNICODE character list I tend to agree that
> code point 0xB5 (MICRO SIGN) should not be converted to
> 0x39C (GREEK CAPITAL LETTER MU). There's 0x3BC for GREEK SMALL LETTER MU.
http://www.unicode.org/Public/UNIDATA/Uni
with an average of
> 40 records per day
>
> How can we check what is going wrong.
> Any memory leak, CPU issue or anything.
>
> Please help me fix it
>
>
>
--
Peter Steinheuser
[email protected]
On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote:
> On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
> > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
> > This must be repeated in each
> > database to be fixed.
>
> including postgres, template0, and template1?
Yes, if y
stgres homepage... is this scheduled maintenance?
do you maybe use Opera?
Regards,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On lör, 2011-12-31 at 17:06 -0800, Jeff Rule wrote:
> Does the postgres server support listening on unix domain sockets on windows?
No.
> It seems to me that they do not, but this is not called out directly in the
> documentation.
>
> Listen_address in postgresql.conf
>
> listen_addresses
Hello Andreas,
Am 15.12.2011 18:40, schrieb [email protected]:
> Zitat von [email protected]:
>> Original-Nachricht
>>> Datum: Thu, 08 Dec 2011 13:04:30 +0100
>>> Von: [email protected]
>>> Zitat von Jan-Peter Seifert :
>
Hello Andreas,
thank you very much for the link.
Original-Nachricht
> Datum: Thu, 08 Dec 2011 13:04:30 +0100
> Von: [email protected]
> Zitat von Jan-Peter Seifert :
> > I wonder whether the number of connections is still limited on
> > Windows 64-bit
.2C_despite_having_capable_hardware
Thank you very much for any new information on this matter.
Peter
--
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
Jetzt informieren: http://www.gmx.net/de/go/freephone
--
Sent via pgsql-admin mailing list ([email protected])
To
On tor, 2011-10-20 at 14:16 -0400, Mark Steben wrote:
> Hi all,
> I'm evaluating the check_postgres program. We are running postgres
> 8.3.
> Does anybody have any experience with this monitoring software they
> would
> like to share? I'm specifically interested in the 'postgres_bloat'
> program
22
> -rw-r--r-- 1 root daemon 51937 2011-09-09 13:45 libuuid.so.16.0.22
> -rwxr-xr-- 1 root daemon 4157970 2011-09-09 13:45 libxml2.so.2
> -rwxr-xr-- 1 root daemon 822303 2011-09-09 14:03 libxslt.so.1
> drwxr-xr-x 4 root daemon4096 2011-08-25 11:20 postgresql
>
> 于2011年9月
On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote:
> This is my env:
> postgres@backup:~$ env
> MANPATH=:/opt/PostgreSQL/9.1/share/man
> SHELL=/bin/bash
> TERM=linux
> USER=postgres
> LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
> PGPORT=3500
> LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;
like like they are not the best way to go
about this, either.
Are there any ideas?
Thanks,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
oo, please?
Thank you very much,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On ons, 2011-02-16 at 13:14 +0100, Bernhard Schrader wrote:
> If i reinitialize the database cluster, won't i have to pg_dump restore
> my data? In this case the downtime would be to big. Therefore I'm
> searching for a faster way.
I said reinitialize your new database cluster. Since you're runn
On mån, 2011-02-14 at 14:18 +0100, Bernhard Schrader wrote:
> As far as I read right now, LC_COLLATE is a read_only variable which
> is used while initdb. But why does the pg_upgrade script doesn't see
> that utf8 and UTF-8 are the same? Is it just a string compare?
Why don't you just reinitializ
).
If you plan to upgrade your PostgreSQL major server version beware of
the removal of some implicit data type casts among other changes as of 8.3.
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello,
Original-Nachricht
> Datum: Mon, 03 Jan 2011 11:05:30 -0500
> Von: Tom Lane
> An: "Jan-Peter Seifert"
> CC: [email protected]
> Betreff: Re: [ADMIN] Obscure problem due to high system OID or privileges?
> "Jan-Peter Seifert&qu
relid max 3318384368 where
another server had max 94363332. The application connects via psqlODBC
(8.4.200).
Is this maybe a known problem?
Could you tell me, please?
Thank you very much,
Peter
--
NEU: FreePhone - kostenlos mobil telefonieren und surfen!
Jetzt informieren: htt
On fre, 2010-12-10 at 10:01 -0800, Wells Oliver wrote:
> Hello- a quick question about logging. I'm trying to set logging to the
> most minimal level possible. e.g. I really don't want to see the
> following kind of thing:
>
> 2010-12-10 09:59:40 PST FATAL: database "woliver" does not exist
>
>
On mån, 2010-12-06 at 00:29 +0200, Imre Oolberg wrote:
> 4. compile
>
> $ make
> ...
> gcc -O2 -Wall -Wmissing-prototypes ...
> ...
> postmaster/postmaster.o: In function `PostmasterMain':
> postmaster.c:(.text+0x420c): undefined reference to `optreset'
> tcop/postgres.o: In function `process_post
On tor, 2010-12-02 at 06:42 -0500, Manasi Save wrote:
> Can anyone provide me any input using the bytea data type for storing binary
> data provides how much benefit on performance as I have millions rows in a
> table using bytea data type also it is index. So how indexing really works on
> byte
tition or better disk.
Good luck,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On tor, 2010-09-23 at 20:55 -0700, Evan Rempel wrote:
> I am running Postgresql 8.3 and would like to get postgres to
> NOT wrap the syslog lines. Is ther any configuration to do this.
> Perhaps I can wrap them at a very large line number?
PostgreSQL 8.4 increased the line length.
--
Sent via
= YES for every
privilege_type on this view for the user in question.
The user is owner of the view and also superuser.
So my question is: is is_grantable not the same as 'WITH GRANT OPTION'?
Could you tell me, please?
Thank you very much,
Peter
P.S. Server version is PostgreSQ
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
--
EATE TABLE table_a_copy AS SELECT * FROM table_a;
Then I load the backed up data with COPY to table_a_copy.
Then I do the update(s).
Of course one could do the updates with a loop, but in my opinion that's rather
inconvenient.
Any hints what the problem is?
Thank you very much,
Peter
P.S. Server
> required vacuuming. Then you need to do some not-hobbled vacuuming
> during your maintenance windows. Eventually probably autovac will have
> some understanding of maintenance windows built-in, but it doesn't yet.
For this application (and most of my databases), I'm fairly
lock on the table in question, and there were several other processes
waiting. It's possible that it was just a symptom of a larger problem
at the time. I didn't have time to do a thorough analysis (and the
problem state is lost now), and what was cause vs. effect is probably
immaterial at
um_vacuum_cost_limit = -1
...
#vacuum_freeze_min_age = 5000
#vacuum_freeze_table_age = 15000
Cheers,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
7;t until I did it. There are no 8.4 MSI installers to be moved.
>
Thank you very much. :)
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
taller' server would be
necessary in order to update to a newer 'one-click only' minor version ...
So ... is pginstaller dead or just delayed this time?
Could you tell me, please?
Thank you very much,
Peter
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischa
e if your filesystem didn't have issues (if postgres
> start, then it is ok from its side)
Sounds good.
Thank you very much for your reply.
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Tue, 2010-05-04 at 14:04 -0600, Scott Marlowe wrote:
> On Tue, May 4, 2010 at 1:41 PM, Peter Sabaini wrote:
> > On Tue, 2010-05-04 at 11:39 -0400, Tom Lane wrote:
> >> Peter Sabaini writes:
> >> > it seems Postgres tries to send a UDP packet to a random high p
On Tue, 2010-05-04 at 11:39 -0400, Tom Lane wrote:
> Peter Sabaini writes:
> > it seems Postgres tries to send a UDP packet to a random high port to
> > communicate with the statistics collector daemon. We have rather strict
> > packet filter rules in place, and I'd lik
sible (setting a compile time or run time parameter)?
Thanks,
peter.
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
using the database(s) or is there a risk of hidden data
corruption (fsync is on)?
Could you tell me, please?
Thank you very much,
Peter
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
--
Sent via pgsql-admin mailing
here wasn't any problem so far because the other PostgreSQL
servers have been installed on non-NTFS file systems?
Good luck,
Peter
Am 12.04.2010 07:25, schrieb Pankaj Mandal (pmandal):
> The scripts are executed by user Administrator on this specific machine
> which has all the privile
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
l createdb (v8.4.x)
(example for LATIN1 and German locale, locale = LC_COLLATE / LC_TYPE in 8.2):
createdb -U postgres -h -p --owner=name_of_owner
--locale=German_Germany.28591 --encoding=LATIN1 --template=template0
database_name
Good luck,
Peter
Original-Nachricht
> D
On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote:
> Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
> > On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
> > > It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
> It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
> are two different stories, hence the seen results.
The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken.
This is becoming a FAQ ...
--
Sent via pgsq
://en.wikipedia.org/wiki/Windows-1252
In your example it seems to be this character:
http://decodeunicode.org/en/u+2219/properties
Clean in it up in the source table if you've identified any problematic
character.
Good luck,
Peter
--
Sent via pgsql-admin mailing list (pgsql-adm
On Wed, Dec 9, 2009 at 3:29 PM, Adam Tauno Williams
wrote:
> On Wed, 2009-12-09 at 15:18 -0600, Peter Koczan wrote:
>> I found the packages. I'm still confused why local ident
>> authentication works even without a running ident server, though. Does
>> anyone know wh
onfused why local ident
authentication works even without a running ident server, though. Does
anyone know why that is?
Thanks,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
local all koczan ident sameuser
hostssl all koczan 127.0.0.1/32 ident sameuser
I'm running Red Hat Enterprise 5.4, and I can't find any place where
an ident server is actually running on this host.
How is it working for local connections, and what mi
On tor, 2009-11-12 at 10:45 -0500, Tom Lane wrote:
> In practice the code path isn't sufficiently used or critical
> enough to be worth trying to make that bulletproof.
Well, the subject line is "recovery is stuck". Not critical enough?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgre
On lör, 2009-09-26 at 12:19 -0400, Tom Lane wrote:
> Peter Eisentraut writes:
> > strace on the backend processes all showed them waiting at
> > futex(0x7f1ee5e21c90, FUTEX_WAIT_PRIVATE, 2, NULL
> > Notably, the first argument was the same for all of them.
>
> Probabl
uery was broken to begin with or did this
change with time / introduction of standard conforming strings?
Thank you very much,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
names like table_username.
This syntax does match as expected though:
SELECT table_name FROM information_schema.views WHERE table_schema =
current_schema() AND table_name LIKE E'\\_%\\_username';
Is this behaviour to be expected?
Thank you very much,
Peter
--
GRATIS für alle GMX-Mitgliede
On Wed, 2009-09-23 at 10:04 -0400, Tom Lane wrote:
> I'd prefer not to go there, at least not without a demonstration that
> this will solve a bug that's unsolvable otherwise. If a child is
> really stuck in a state that doesn't accept SIGQUIT, it probably
> won't accept SIGKILL either (eg, uninte
I have observed the following situation a few times now (weeks or months
apart), most recently with 8.3.7. Some postgres child process crashes.
The postmaster notices and sends SIGQUIT to all other children. Once
all other children have exited, it would enter recovery. But for some
reason, some
ugger, debugging functions listed in
pldbgapi.sql etc.).
Could you tell me, please?
Thank you very much,
Peter
--
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
--
Sent via pgsql-admin mailing list (pgsql-
r machine or totally switch it off if you haven't already.
I forgot this link:
http://www.postgresql.org/docs/8.3/static/app-pg-ctl.html
Under windows you have to specify the password for the
Windows-postgres-user when registering the server as a service ...
regards,
Peter
> > To
or SQL I'll stick with "textin(regprocedureout(p.oid::regprocedure))".
Peter
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser
--
Sent via pgsql-admin mailing list (pgsql-admin@po
27;t forget to change the auth-option back.
Good luck,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
_schema();
It works fine on 8.3. It fails on 8.2 with the error message that conversion to
text is not possible for data type regprocedure.
I didn't see any explicit type cast in 8.3 for regprocedure -> text. Is there a
way to add it in 8.2?
Thank you very much,
Peter
--
GRATIS
Cheers,
> Mario
>
> --
> Sent via pgsql-admin mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Peter Steinheuser
[email protected]
On Wednesday 22 July 2009 08:25:36 Deepak Bala wrote:
> Hi everyone,
>
> I have some queries regarding the PITR backup procedure on Postgres
> 8.3. Here are the steps I follow for backup
>
> 1. I set up WAL archiving and checked that this is working.
> 2. Execute SELECT pg_start_backup('label')
> 3
locale=German_Germany.28591 -W -A md5 -D
"C:\Programme\PostgreSQL\8.3\data"
Good luck,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Saturday 04 July 2009 20:44:11 Ransika de Silva wrote:
> I have a requirement of storing multilingual words and hence planing to
> utilize the Unicode support of the database tables. The question that I
> have is, will there be a problem if I make the primary key of a table
> multilingual,
Not
On Friday 22 May 2009 06:51:42 Cliff Pratt wrote:
> I've browsed my history of the list, and the Internet for information
> regarding giving the unix 'postgres' user a shell of /bin/false, so
> that it cannot be logged into directly. It seems from my research that
> if I set the user's shell to /bi
On Wednesday 20 May 2009 23:51:53 Arnold, Sandra wrote:
> One of my security controls is to audit events. I don't have a problem
> on how to do that. However, another control is for all functionality of
> the PostgreSQL database to cease or stall if the directory that contains
> the audit logs is
ipt from a newer server version? I
checked the dblink uninstall scripts from the major versions 8.2, 8.3 and 8.4
for example. There weren't any significant differences but I'd like to make
sure.
Could you tell me, please?
Thank you very much,
Peter
--
Neu: GMX FreeDSL Komplettans
ller/cetixx/entry/volltextsuche_mit_postgresql_8_2
You have to download them from the snowball site it seems:
http://snowball.tartarus.org/algorithms/german/
Isn't tsearch2 part of the core since 8.3?
Good luck,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to y
Paul Rogers schrieb:
If so then how did you handle permissions, errors, connection pooling?
Hey there!
I'm currently working on an .NET application with user- and
privilege-management via database.
Privileges and access to frontend modules (in the application), tables,
functions etc. (in d
n up additional log files created
because the original log file became bigger than log_rotation_size?
Thank you very much,
Peter
--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss
für nur 17,95 Euro/mtl.!*
http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD
' PASSWORD ' ||
quote_literal($2) || ' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE';
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER;
Nevertheless - thanks for thinking ;-),
Hans Peter Ertz
--
Sent via pgsql-admin mailing list ([email protected]
unction...
At the moment I'm running out of ideas...can anyone help?
Greetings and TIA,
Hans Peter Ertz
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
o be dumped in non-text formats. This might have changed
since 7.4, but I couldn't find any source either way.
Hope this helps.
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
. on to
so.). Less confusing would be "Erbt Rechte von anderen Rollen (INHERIT)".
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Sunday 22 March 2009 06:26:02 Caleb Cushing wrote:
> COPY blarg (blah, bleh, blerg) FROM stdin;
> 1 random character data
> djfa;djjf;sdjl;afkjeoiuoiejk,cxjueiojiojeef98hkjdyf98y92hvniay8syfkdnf38932
>hrhf9e83uifnskjj3h9r83hhjnnn2iyfhkjsndfi7y938hnksu879hf089h3n299ssdjfh92
>3
>
> the a
ybody have experience creating a database with multiple owners like
this?
Thanks for your help!
~ Peter
ump file was obsolete.
You might need some more options for piping (-U etc.):
http://www.postgresql.org/docs/8.3/interactive/app-pg-dumpall.html
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
memory that prevented PostgreSQL from (re-)starting sometimes. So if you
don't have an actual PostgreSQL try rebooting the system ...
What do the Windows system logs say? Do you have anti-virus software
running? Google for the error code ...
Good luck,
Peter
--
Sent via pgsql-admin mai
public.plpgsql_validator(oid)
They are obviously relicts from an earlier PostgreSQL-version. Could they cause
problems if left be although the new versions are now in pg_catalog which
obviously is being searched before all other schemata?
But why is regprocedure not just addding the schema to
#x27;-functions?:
SELECT DISTINCT p.oid::regprocedure::text FROM pg_catalog.pg_proc p LEFT JOIN
pg_catalog.pg_namespace n ON n.oid = p.pronamespace WHERE nspname !~* '^pg_'
AND nspname != 'information_schema'
Thank you very much,
Peter
--
Computer Bild Tarifsieger! GMX FreeDSL - Telefonan
AND nspname != 'information_schema';
Thank you very much again,
Peter
--
Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen:
http://www.gmx.net/de/go/multimessenger01
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
you very much to both of you.
Peter
--
Computer Bild Tarifsieger! GMX FreeDSL - Telefonanschluss + DSL
für nur 17,95 ¿/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.post
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could invent workarounds such as recovering to
the point where you are happy with your restored one database, and then
restore the other n-1 databases from an
w.postgresql.org/docs/8.3/interactive/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE
Obviously you can't just use the specific_name from
information_schema.routine_privileges for this.
Any help is appreciated.
Thank you very much,
Peter
--
Computer Bild Tarifsieger! GMX FreeDSL - Telefo
Tom Lane schrieb:
> Peter Hinse writes:
>> More info: the statement is an INSERT with some huge subselects, running
>> every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all
>> occasions, the job terminates in about 1-2 minutes - however, sometimes
>> it jus
e password it is asking is not login password?
>
> Can somebody please help?
Try setting the authentification method for local (127.0.0.1) to trust
in the pg_hba.conf file (it's in the cluster directory together with
postgresql.conf. Then set a new password for postgres via SQL, pgAdmin
II
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
Tom Lane schrieb:
> Peter Hinse writes:
>> More info: the statement is an INSERT with some huge subselects, running
>> every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all
>> occasions, the job terminates in about 1-2 minutes - however, sometimes
>> it jus
CentOS 4.7 x86_64. In 97% of all
occasions, the job terminates in about 1-2 minutes - however, sometimes
it just hangs. If terminated with kill and restarted, it always
terminates.
Clueless,
Peter
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your
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@postg
.org/docs/8.3/interactive/monitoring-stats.html
Neither pg_stat_clear_snapshot() nor pg_stat_reset() did had any effect though.
So how do I reset the server / cache reliably?
Thank you very much for any hints in advance,
Peter Seifert
--
Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`
1 - 100 of 851 matches
Mail list logo
