Hi all
This is H Reddy Iam new to postgresql I have a problem connecting to server
from client in LAN
can any one help me how to configure client/server environment.
Iam getting this error:
psql: could not connect to server: No route to host
Is the server running on host "192.168.9.111" an
H Reddy,
- Are you sure that the server is up and running?
- Are you sure that the server is accepting TCP/IP connections
and not just using sockets?
- Are you on the same box as the server?
- Have you tried reading the manual pages?
Best wishes,
gb.-
On Mon, Sep 15, 2008 at
Run top, hit M and the attach the output to a reply here and we'll take a look.
On Mon, Sep 15, 2008 at 5:33 AM, Vivek_Sharan <[EMAIL PROTECTED]> wrote:
> Thanks for your reply but how would I calculate which processes are eating up
> more memory, When I check process list, its only postgres and
Hi
While running a VACUUM ANALYZE
The process aborts and I receive the following message in the log:
ERROR: could not open relation 16388/24734/51896: Cannot open or remove a
file containing a running program.
STATEMENT: VACUUM ANALYZE
51896 refers to an index on a table with over 10,000,000 ro
Hi pgsql-admin mailing list,
I'm having some problems setting up access privileges via pg_hba.conf. The
problem is that it seems that some Linux user accounts have password-less
access to the pgsql databases via the 'pgsql' CLI tool even though I try to
enforce md5 password protection.
The releva
On Mon, 15 Sep 2008 11:31:21 -0400
[EMAIL PROTECTED] wrote:
> Hi
> While running a VACUUM ANALYZE
> The process aborts and I receive the following message in the log:
>
> ERROR: could not open relation 16388/24734/51896: Cannot open or
> remove a file containing a running program.
> STATEMENT: V
[EMAIL PROTECTED] writes:
> The relevant line in pg_hba.conf is this:
> hostall mette,mkrist 10.10.0.0255.255.0.0 md5
What are the *other* lines in pg_hba.conf?
> I can't find anything in the documentation about exceptions from the
> pg_hba.conf rules,
There aren'
Dear PG members,I want to know that does begin and end in plpgsql are
related to begin transactions and commit? if yes/no how? If I start to
execute a function of multiple statements does PG commits each transaction
within a function, or whole function as a transaction.
Also if first statement make
On Mon, Sep 15, 2008 at 01:08:08PM -0400, Tom Lane wrote:
...
> forgot to SIGHUP the postmaster, (4) you have a ~/.pgpass file on
> the client side that is silently supplying a password in some of
> these cases.
It seems the user had this ~/.pgpass file and that this was the reason. Thanks
for poi
On Mon, Sep 15, 2008 at 10:55 AM, c k <[EMAIL PROTECTED]> wrote:
> Dear PG members,
> I want to know that does begin and end in plpgsql are related to begin
> transactions and commit? if yes/no how?
No. a plpgsql function is a transaction in its entirety. If called
within a transaction it inheri
On Mon, Sep 15, 2008 at 11:22 PM, c k <[EMAIL PROTECTED]> wrote:
> If I have a function having:begin
> insert into something ...
> select max(primary key) from something..
> end;
>
> does the second statement within a function can view the results after
> execution of first statement to get max(P.
On Mon, Sep 15, 2008 at 11:53 AM, c k <[EMAIL PROTECTED]> wrote:
>
>
> If I have a function having:
> begin
> insert into something ...
> select max(primary key) from something..
> end;
>
> does the second statement within a function can view the results after
> execution of first statement to get
Thanks for your reply but how would I calculate which processes are eating up
more memory, When I check process list, its only postgres and apache processes
running on my system and only postgres processes are heavy. System runs out of
memory quickly.
Regards,
~Vivek
-Original Message
This sort of depends on what you want to do with the ERD. If I want
to document an existing system, I use Aqua Data Studio. It's not
free, but it will take an existing system and draw the ERD for you
based on the relationships it finds in the database. There are
things that I don't like
MICRO-OLAP Database designer for postgres is a great tool.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de Carol Walter
Enviado el: lunes, 15 de septiembre de 2008 02:58 p.m.
Para: Thomas Jacob
CC: Barbara Stephenson; pgsql-admin@postgresql.org
Asunto: Re:
I have a database that I use for testing. The contents are not
particularly critical; if I were to lose that data, it would be an
annoyance but not a disaster. Thus I do not back up the DB.
My server machine (actually my windows workstation) became very ill, so
the IT folks gave me a new worksta
Thank you all for your input. Yes I would like to get an ERD for an existing
system plus to create a new system.
All the ones recommended are any of them for Linux. Our database resides on
Redhat 4. I prefer free/open source so I can at least take a look to see if
it's user friendly. Howeve
My databases are running on top of Solaris 10, but I don't think
RedHat should be a problem. Aqua Data Studio is one of the products
that allow you to do the trial version.
Carol
On Sep 15, 2008, at 3:34 PM, Barbara Stephenson wrote:
Thank you all for your input. Yes I would like to get a
On Mon, Sep 15, 2008 at 1:09 PM, Eliot, Christopher
<[EMAIL PROTECTED]> wrote:
> I have a database that I use for testing. The contents are not particularly
> critical; if I were to lose that data, it would be an annoyance but not a
> disaster. Thus I do not back up the DB.
>
> My server machine
On Mon, Sep 15, 2008 at 1:09 PM, Eliot, Christopher
<[EMAIL PROTECTED]> wrote:
> My server machine (actually my windows workstation) became very ill, so the
> IT folks gave me a new workstation, but installed the disk drive from the
> old workstation in the new one as a secondary drive.
P.s. the p
Hello list,
I've been a PostGres user for a while, but am just now having to implement some
security for a project. The hope is that we can create an environment through
Roles that would allow users the ability to create a database(s) and have
access to their database(s) but not have access to
Yes, in fact I installed postgreSQL, renamed the newly-created "data"
directory, and then copied over the old data directory.
When that didn't work I renamed my new data directory off to another
name and restored the data directory that was created as part of the
installation, and was able to succe
Trent Pingenot <[EMAIL PROTECTED]> writes:
> I've been a PostGres user for a while, but am just now having to implement
> some security for a project. The hope is that we can create an environment
> through Roles that would allow users the ability to create a database(s) and
> have access to th
Hi All;
I'm unclear per the docs what the effect is of specifying a shared
buffers value without a kB or an MB at the end.
For example if I specify shared buffers as:
shared_buffers = 5000
would this equate to 5000 8K pages, or 5000K, 5000bytes?
I usually specify the buffers in MB but I w
kevin kempter <[EMAIL PROTECTED]> writes:
> I'm unclear per the docs what the effect is of specifying a shared
> buffers value without a kB or an MB at the end.
> For example if I specify shared buffers as:
> shared_buffers = 5000
> would this equate to 5000 8K pages, or 5000K, 5000bytes?
Pages.
Thanks !
On Sep 15, 2008, at 7:10 PM, Tom Lane wrote:
kevin kempter <[EMAIL PROTECTED]> writes:
I'm unclear per the docs what the effect is of specifying a shared
buffers value without a kB or an MB at the end.
For example if I specify shared buffers as:
shared_buffers = 5000
would this equat
Hi gb
Thanks for your reply,
Ya the sever is up and running, i don't know how to check weather the
server is accepting TCP/IP connections.
The sever is in different box.
i read the manual pages I am not getting..
Regards
Hanumantha Reddy
Hi,
I try to read bytea column from postgresql db over a dblink in Oracle DB.
But I could not. How can I solve the problem?
In windows environment there is a parameter in odbc driver bytea as LO. I
could not find how to set it on unix odbc.
Versions of products I Use:
Postgresql 8.3.3 on redhat
28 matches
Mail list logo
