On Thu, Nov 10, 2016 at 3:10 AM, nore...@evolu-s.it wrote:
> Someone else facing this problem?
Saw that a couple of times. Anti-virus softwares on Windows are known
to interact badly with Postgres instances if no filters are applied or
if they are kept around running.
--
Michael
--
Sent via p
Hi again,
our support team is reporting cases where postgres connections are
suddenly dropped, but reconnecting again soon everyting is OK.
Environment is PostgreSQL 9.1 on Windows (various versions)
Asfer some research, I found on postgresql log many of these messages
could not reserve shar
You really need to show the full, exact text of the error from the database as
well as the SQL run by both apps and relevant details of table structures.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
On 01/23/2013 04:41 PM, MarkB wrote:
I have written a program where 2 computers are connected to the same
database. The first PC executes an update statement and then sends a
notification. This makes the second PC execute a select statement on the
same table. The second PC then gets an error:
'F
MarkB wrote:
> I have written a program where 2 computers are connected to the same
> database. The first PC executes an update statement and then sends a
> notification. This makes the second PC execute a select statement on the
> same table. The second PC then gets an error:
>
> 'Field "Fieldna
I have written a program where 2 computers are connected to the same
database. The first PC executes an update statement and then sends a
notification. This makes the second PC execute a select statement on the
same table. The second PC then gets an error:
'Field "Fieldname" not found'
I have no
On 18/10/2012 15:47, GMAIL wrote:
> i have created two cluster in the same host the first called "main" with
> port 5432 the second called "remote" with port 5433.
> but when i try to connect with pgadmin3 to the second cluster i get the
> error "authentication failed".
> if i try to connect to the
i have created two cluster in the same host the first called "main" with
port 5432 the second called "remote" with port 5433.
but when i try to connect with pgadmin3 to the second cluster i get the
error "authentication failed".
if i try to connect to the first cluster i don't have any kind of p
Ok, I will try that.
Thanks to all for the information.
Best Regards
José Santos
> Date: Fri, 31 Aug 2012 08:08:06 -0700
> From: adrian.kla...@gmail.com
> To: zpsant...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Postgresql Error ask for passwor
On 08/31/2012 08:03 AM, José Pedro Santos wrote:
> I install the FGS distribution of MapServer, after, the plugin Postgres
> - Server. When I go to root and put in bash SU also ask for password...
Here is an answer from the FGS mailing list:
http://lists.maptools.org/pipermail/foss-gis-suite/20
stgresql.org
> Subject: Re: [GENERAL] Postgresql Error ask for password
>
> On 08/31/2012 07:29 AM, José Pedro Santos wrote:
> > Dear all,
> >
> > Im trying to install one application in my Linux but when I try to use
> > the expression SU postgresql it ask for pass
Pedro Santos wrote:
> Im trying to install one application in my Linux but when I try to use the
> expression SU postgresql it
> ask for password, what is the password? I try my root password but dont work.
It may be that you never set that password.
Try "grep postgresql /etc/shadow" as root use
On 31.08.2012 16:29, José Pedro Santos wrote:
> Dear all,
>
> Im trying to install one application in my Linux but when I try to use
> the expression SU postgresql it ask for password, what is the
> password? I try my root password but dont work.
Sorry, you are a bit terse on the context of this.
On 08/31/2012 07:29 AM, José Pedro Santos wrote:
Dear all,
Im trying to install one application in my Linux but when I try to use
the expression SU postgresql it ask for password, what is the password?
I try my root password but dont work.
More information is needed.
What variety of Linux are
Dear all,
Im trying to install one application in my Linux but when I try to use the
expression SU postgresql it ask for password, what is the password? I try my
root password but dont work.
Thanks for your time
Ciao
Jose Santos
I have restarted the cluster with "ignore_system_indexes=true" and was able
to connect to databases.
I have started re-indexing, seems to be working fine. Will get back if i
find further issues.
Regards,
Venkat
On Wed, Jul 4, 2012 at 3:35 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote
>
> Re-index option did not work.
>
> Single user mode option did not work as well -
>
> [postgres@localhost bin]$ postgres --single oltp_db -E -D
> /usr/local/postgresql-9.0.1/data
> 2012-07-04 04:30:47 CDT [26072]: [1-1] user=,db= FATAL: index
> "pg_attribute_relid_attnum_index" contains unexpe
On Wed, Jul 4, 2012 at 2:12 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Wed, Jul 4, 2012 at 2:11 PM, Raghavendra <
> raghavendra@enterprisedb.com> wrote:
>
>> \
>>> postgres=# \c oltp_db
>>> FATAL: index "pg_attribute_relid_attnum_index" contains unexpected
>>> zero page
On Wed, Jul 4, 2012 at 2:11 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> \
>> postgres=# \c oltp_db
>> FATAL: index "pg_attribute_relid_attnum_index" contains unexpected zero
>> page at block 0
>> HINT: Please REINDEX it.
>> Previous connection kept
>>
>> Can anyone please help
>
> \
> postgres=# \c oltp_db
> FATAL: index "pg_attribute_relid_attnum_index" contains unexpected zero
> page at block 0
> HINT: Please REINDEX it.
> Previous connection kept
>
> Can anyone please help us.
>
>
You have HINT given to REINDEX it. Use reindexdb from OS.
---
Regards,
Raghavendra
En
Hello Community,
We have a critical situation where-in our production database server got
effected by "Root Kit".
When tried to build a replication site by copying the data directory to a
different server, so many files got missed while copying (this is due to
root kit effect).
So, we moved the
"Bob Pawley" writes:
> I have an interface (Delphi) for my Postgresql database, that is telling me
> that I have an inconsistancy between one of the Postgresql triggers and a
> Postgresql table. The problem for me is - the message doesn't give me enough
> information to determine which trigger
Hi
I have an interface (Delphi) for my Postgresql database, that is telling me
that I have an inconsistancy between one of the Postgresql triggers and a
Postgresql table. The problem for me is - the message doesn't give me enough
information to determine which trigger has the error.
Is there s
On Mon, 2009-09-28 at 10:22 -0400, Tom Lane wrote:
> Vasiliy G Tolstov writes:
> >> some time (meybe every four day) postgresql get error to all clients
> >> what try to connect , a can attach strace to it:
>
> >> 1. What error?
>
> > postg...@calipso ~ $ psql
> > psql: FATAL: semctl(1048608, 15
Vasiliy G Tolstov writes:
>> some time (meybe every four day) postgresql get error to all clients
>> what try to connect , a can attach strace to it:
>> 1. What error?
> postg...@calipso ~ $ psql
> psql: FATAL: semctl(1048608, 15, SETVAL, 0) failed: Invalid argument
My bet is that something has
On Mon, Sep 28, 2009 at 02:33:36PM +0400, Vasiliy G Tolstov wrote:
> Hello!
>
> I'm using postgresql (8.0.15) on Gentoo Linux (2.6.27.29-titan #2 SMP
> Sun Aug 16 15:12:53 MSD 2009 x86_64 Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
> GenuineIntel GNU/Linux)
>
> some time (meybe every four day) postgresq
В Пнд, 28/09/2009 в 13:11 +0200, Martijn van Oosterhout пишет:
> On Mon, Sep 28, 2009 at 02:33:36PM +0400, Vasiliy G Tolstov wrote:
> > Hello!
> >
> > I'm using postgresql (8.0.15) on Gentoo Linux (2.6.27.29-titan #2 SMP
> > Sun Aug 16 15:12:53 MSD 2009 x86_64 Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
Hello!
I'm using postgresql (8.0.15) on Gentoo Linux (2.6.27.29-titan #2 SMP
Sun Aug 16 15:12:53 MSD 2009 x86_64 Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
GenuineIntel GNU/Linux)
some time (meybe every four day) postgresql get error to all clients
what try to connect , a can attach strace to it:
post
ld version of the postgres app..
>
> thanks
>
> bruce
>
>
> -Original Message-
> From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 12, 2005 3:30 PM
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERA
ECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgresql error
On Sat, 12 Mar 2005 10:13:34 -0800, bruce <[EMAIL PROTECTED]> wrote:
> hi...
>
> i get a postgres error when i've gone from RH8 to FC3 and am now using
> postgreSQL-7.4.7.
>
> an err msg
On Sat, 12 Mar 2005 10:13:34 -0800, bruce <[EMAIL PROTECTED]> wrote:
> hi...
>
> i get a postgres error when i've gone from RH8 to FC3 and am now using
> postgreSQL-7.4.7.
>
> an err msg 'an old version of database format was found. you need to upgrade
> the data format."
>
> searching googl
hi...
i get a postgres error when i've gone from RH8 to FC3 and am now using
postgreSQL-7.4.7.
an err msg 'an old version of database format was found. you need to upgrade
the data format."
searching google shows that others have seen this, but i can't find a way to
correct it. i've checked
When I'm running my app, I occaisonally receive this error message:
PostgreSQL Error Code(1)
"could not create socket: An address incompatible with the requested
protocol was used"
It appears to be a PostgreSQL Error, but I can't find Any documentation on
it at all in the PostgreSQL docs, or web
33 matches
Mail list logo
