Hi ,
My requirement is, I have
to create a PostgreSQL database that is present in the server in
a local machine which does not have PostgreSQL installation at all .
Please explain how to do this
?
Thanks
Chandana
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Title: Using SSL for secure connections to the DB
Hi Everyone,
Hope you guys can help.
I moved our Database to a separate server and I would like to use SSL for all connections (The server runs RH9, PostgreSQL 8).
I read the postgresql documentation and setup everything accordingly. I.e
Hi ,
Is it possible to create
a local copy of PostgreSQL database that is present in server even without
installation of PostgreSQL in the local machine.?
Thanks in advance
Regards
Chandana
Hello,
I have read some posts in the pg-admin list.
Before I go at it, I thought I'd ask again.
Thanks in advance for any pointers.
I am trying to see if there are any
useful data in an older PostgreSQL
installation, for a client.
This client, a businessman, not a computer person,
has had a few D
Hi all,
When I create a database dump in python script and if there are some errors
(user_name is not correct, db_name doesn't exist or something else) I need to
send e-mail notification to admin. How can I handle these errors?
Example:
--
Tom,
Thanks for the advice. I'll track it over the next couple weeks and see
what comes up.
Mark
On Tue, 2006-05-09 at 17:01 -0400, Tom Lane wrote:
> <[EMAIL PROTECTED]> writes:
> > I had an odd situation occur this morning with PGSQL 7.4 run on Red Hat
> > Enterprise 4 (update 3) and could re
Is there a way inside of Postgresql to automatically terminate idle
connections? I would like to terminate any connection to my database
that has not has any activity for a specified period of time. I would
like to be able to do this despite the state of the connection (the
majority of my truly i
<[EMAIL PROTECTED]> writes:
> I had an odd situation occur this morning with PGSQL 7.4 run on Red Hat
> Enterprise 4 (update 3) and could really use some wisdom.
> ... Single postmaster running.
> ... vacuum full is run every night as part of a cron job
> ... At start, data files consume abo
Everyone,
I had an odd situation occur this morning with PGSQL 7.4 run on Red Hat
Enterprise 4 (update 3) and could really use some wisdom.
... Single postmaster running.
... vacuum full is run every night as part of a cron job
... At start, data files consume about 28 GB
... This morning
Select setval('mytable_id_seq',1);
So when I insert a new row the value will be "2" and not "1" as it should be
Select setval('mytable_id_seq',1,false);
http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html
HTH.
Ben K.
Developer
http://benix.tamu.edu
Your Windows user account information will
not be useful in Postgres.
When you install it, it will ask you for
two accounts:
1 is the service account (the machine account
which Postgres runs under)
The other is the PostgreSQL super user.
Until you set up other user accounts, you will
Arnau wrote:
Hi all,
I have problems droppping some tables in a DB running on postgreSQL
7.4.2. Below you have an example of what is happening:
coltr_demo=# drop table agenda_users_groups;
ERROR: could not find tuple for trigger 112070831
I haven't found anything about how to solve this
this has been installed successfully. the new problem is
C:\Program Files\PostgreSQL\8.1\bin>createdb HtlMgmtDBPassword:createdb: could not connect to database postgres: FATAL: password authentication failed for user "afolorunsho"
afolorunsho is the user that signed on windows operating system.
> however, now that i
have installed not as a service, how do i correct it?
If this is a new installation and you’ve
not loaded any data yet, I’d say the easiest way would be to uninstall
and re-install it again (it would also give you chance to double-check where
the data directory is
You should ideally install it as a Windows
service. You can restrict access to the server using the pg_hba.conf to the
local machine only so other network machines cannot connect. The windows
service means that PostgreSQL can be controlled automatically at startup,
rather than have to be
Hi Jim
I have considered your comments and they make good sense. As the 2 existing
systems integrate with the new one, they will work more and more closely, so
I will work on doing as you suggest.
Gary
On Thursday 04 May 2006 19:21, Jim C. Nasby wrote:
> I think a better question to be asking
Im a new user, having read so much about the database.
i installed the binary version successfuly on windows. I did not install as a service, as all access have to be through the local host, via a program(java). Now how do i create the database at a specified directory and start using this.
Hi all,
I have problems droppping some tables in a DB running on postgreSQL
7.4.2. Below you have an example of what is happening:
coltr_demo=# drop table agenda_users_groups;
ERROR: could not find tuple for trigger 112070831
I haven't found anything about how to solve this, anybody know
Hi,You could generate a common script to reset all the sequence using:select 'alter sequence '||relname||' restart with 1 ;' from pg_class where relkind='S' ;Then execute the output of that script to restart all the sequences from 1. Does that solve your problem?Regards,-ThusithaPascal Tufenkji <[E
20 matches
Mail list logo
