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 the
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
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
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
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 localhost
Hi...
When i am trying to connect to the database
in the localwindows 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
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
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
Hi everybody:
I need help with NHibernate in an application developed in C# using a database in PostGreSQL. Any help please!
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 info
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
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
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 db
path/base/oid/ 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
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 db
path/base/oid/ to the actual name (ie tablea, indexb, etc...),
and I have ran into files that are not in the pg_class table. I
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 [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
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 networking
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 Arias
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
look at
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
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
-- 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
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?
Hm.
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
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 performance
25 matches
Mail list logo