On Wed, Jan 04, 2006 at 10:51:55 +0200,
Tsirkin Evgeny <[EMAIL PROTECTED]> wrote:
>
> > What you want to do in the trigger isinsert a new row into a table that
> > contains the change in count, instead of trying to update a single row
> > for each value/ident (btw, you'll probably get better per
Tom Lane pravi:
Tomaz Borstnar <[EMAIL PROTECTED]> writes:
Jeff Frost pravi:
Seems like you're going to have to kill -9.
Yeah, this is bad :( Seems like kill -9 is needed when disk is full. Tested on
*BSD jails.
With what PG version?
8.0.x for sure.
And what behavior did you see exact
On Wed, 2006-01-04 at 12:51 -0500, Tom Lane wrote:
> markos <[EMAIL PROTECTED]> writes:
> > psql -h localhost -U markulis
> > psql: could not connect to server: Network is unreachable
> > Is the server running on host "localhost" and accepting
> > TCP/IP connections on port 5432?
>
-- Richard Doust wrote --
> Is it perhaps looking elsewhere for pg_hba.conf? If so, how can I
> find out? I'm sure this must be incredibly easy, but it's annoying me
> at this point?
Have you tried `locate pg_hba.conf`? That'll at least tell you if there are any
others floating
ar
I have just done a new compile and install of postgresql 8.1.0 on a
Mac running OS X 10.4.3 Server. This machine hosted a postgres
database in a production web application environment until recently
when I moved the application and the database to a different host on
the network. My intent
Hi Guys,
Just wondering if there is a way to specify the priority that the PostgreSQL
server runs at on a Windows 2003 server as I want to raise the server
priority 1 notch to be above some other processes running on that machine?
Cheers
Alex Shepherd
---(end of broadc
On 1/4/06, Alain Rodriguez Arias <[EMAIL PROTECTED]> wrote:
> I don't know what else to tell you
> The error I receive said:
> Could not insert Prision#1
> My example is based on a Prision with a sequence for id and a bytea field
> for saving images.
> I don't know if this is enough.
> Thanks
>
I don't know what else to tell you
The error I receive said:
Could not insert Prision#1
My example is based on a Prision with a sequence for id and a bytea field for saving images.
I don't know if this is enough.
Thanks
On 1/4/06, Snoof <[EMAIL PROTECTED]> wrote:
-- Alain Rodriguez Ar
markos <[EMAIL PROTECTED]> writes:
> psql -h localhost -U markulis
> psql: could not connect to server: Network is unreachable
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?
Hm. "Network is unreachable" means that you have got a networ
Chris Hoover <[EMAIL PROTECTED]> writes:
> I have some file in my database directories that I can not find an purpose
> to.
Read http://www.postgresql.org/docs/8.0/static/storage.html
Some of this doesn't apply to PG 7.3, but most of it does. In
particular I suspect you are confused about oid vs
First of all, thanks for the swift replies.
The whole error message is actually this :
psql -h localhost -U markulis
psql: could not connect to server: Network is unreachable
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
the result of
Chris Hoover wrote:
> I have some file in my database directories that I can not find an
> purpose to.
>
> What I have been doing is trying to relate each file in my path>/base// to the actual name (ie tablea, indexb, etc...),
> and I have ran into files that are not in the pg_class table. I a
I have some file in my database directories that I can not find an purpose to.
What I have been doing is trying to relate each file in my /base// to the actual name (ie tablea, indexb,
etc...), and I have ran into files that are not in the pg_class
table. I am not sure where else to look for the
ok sorry
The thing is that I need to develop a Data Access Layer with NHibernate. I use Hibernate in a J2EE proyect without any problem. But when I tried to use NHibernate for doing the same thing with C# I had troubles. I'm able to create a transaction but when I try to insert or update i rece
sorry ,but i had to go with my job so i have killed one of the backends
and this made the post restart.
However befor this i have done another backtrace ,the one that was hang
in the middle of SELECT (not startup)
and got this:
#0 0xe410 in ?? ()
#1 0xbfffcf08 in ?? ()
#2 0x0001 in
On 1/4/06, Alain Rodriguez Arias <[EMAIL PROTECTED]> wrote:
> Hi everybody:
> I need help with NHibernate in an application developed in C# using a
> database in PostGreSQL. Any help please!
be more specific please... no matter in which list you ask you can't
expect any help with the little in
markos <[EMAIL PROTECTED]> writes:
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?
Please show the *entire* error message, not just the part you think
is important.
regards, tom lane
---(
Hi everybody:
I need help with NHibernate in an application developed in C# using a database in PostGreSQL. Any help please!
Tsirkin Evgeny <[EMAIL PROTECTED]> writes:
> Today i was trying to run an old ver. of an application on test server .
> After a while i have got the pg hangs :
It looks like someone is holding a critical LWLock --- hard to tell if
it's the BufMgrLock or a per-buffer lock for a system index's metap
If i am using local host..Should we not use IP
addree of that .
like:
char ConnInfo[]={"dbname=pilot user=postgres
password=megarac host=localhost port=5432"};
When iam giving host = 10.9.8.54(local ip where the DB is
running)...The following error iam getting
Connection to database
fai
Hi...
When i am trying to connect to the database
in the local windows system where database server is running as
service
I am getting the following error
message.
Connection to database
failedFATAL: no pg_hba.conf entry for host "10.0.0.205",
user "postgres", database "pilot", SSL offP
Hi,
can you check if postmaster is running on your machine using the
following command
ps -aef | grep postmaster
Also check check if postgres is listening on port 5432 using
netstat -na | grep ':5432'
On 1/4/06, markos <[EMAIL PROTECTED]> wrote:
> Is the server running on host "localhos
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
Now, I'm really confused because I used to have postgre 7 installed on
my Debian without any serious problems with the configuration. Right
now, I'm using Ubuntu Breezy and postgre 8.
I have u
Forgot to mention this SUSE 9 with the default 2.6.5 kernel.
Logs does not show anything strange and post refuses to shutdown
gracefully or receive connections.Processes just hangs out there ... .
Evgeny.
On Wed, 4 Jan 2006, Tsirkin Evgeny wrote:
> Today i was trying to run an old ver. of an app
Today i was trying to run an old ver. of an application on test server .
After a while i have got the pg hangs :
9899 ?S 0:00 postgres: [local] SELECT
9932 ?S 0:00 postgres: [local] SELECT
9933 ?S 0:00 postgres: [local] startup
9936 ?S 0:00 p
Evgeny.
On Tue, 3 Jan 2006, Jim C. Nasby wrote:
> On Mon, Jan 02, 2006 at 11:36:11AM +0200, Tsirkin Evgeny wrote:
> > Thanks for answer.However i have already searched for a way to make count
> > faster and didn't find anything.
> > Any pointers will be appreciated.
>
> What you want to do in t
26 matches
Mail list logo
