ssible to have host & hostssl entry in single pg_hba.conf ?
TIA.
--
Regards,
A.Bhuvaneswaran
Systems Engineer
signature.asc
Description: This is a digitally signed message part
w which sql comes from which connection.
Regards,
A.Bhuvaneswaran
signature.asc
Description: This is a digitally signed message part
> Hi,
> could you please let me know how to represent an image when creating a data
> table using
> postgresql
Refer the documentation for details on lo_import and lo_export
functions. It must help you.
regards,
bhuvaneswaran
---
Disclaimer: http://www.bksystems.co.in/email-policy/disclaimer.t
> could you please let me know how to represent an image when creating a data
> table using
> postgresql
Refer the documentation for details on lo_import and lo_export
functions. It must help you.
regards,
bhuvaneswaran
signature.asc
Description: This is a digitally signed message part
> A command for remove the column but it not work
> it gives parse error
> ALTER TABLE tablename DROP COLUMN fieldname;
drop column feature is implemented since 7.3. So, you please check out
your version.
regards,
bhuvaneswaran
signature.asc
Description: This is a digitally signed message part
> databases, and pg_dumpall is suited to dumping a database _system_ (ie,
> multiple databases on one host).
>
Right.
> pg_dumpall seems to do this for me, without any command-line args
> needed. Am I correct in saying that 'pg_dumpall > filename' will produce
> a PostgreSQL dump that include
> Unsurprising. An inequality condition may require fetching many rows
> (the planner is estimating 336289 rows here...) and so an indexscan is
> not necessarily quicker. Have you compared actual runtimes with
> enable_seqscan on and off?
I did run with enable_seqscan off. You are right, the pl
Hi,
I am using pgsql 7.3.4 on rh7.3.
I have a table and an index on it. The index is used when i use '='
operator for the indexed field in the where condition. But the index is
not used when i use '>=' operator for the same field. Herewith i have
attached the explain output. Hope to get some ligh
> in postgresql there is any system variable for update
No such built-in feature is available. But, we can write a before
trigger on update event to set the modified time.
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 7: don't forget to in
> You need to double quote the name to preserve case.
IMO, in 7.3.4, these two scripts (createuser & dropuser) preserve the
case by default even without double quote. For example, 'createuser
Admin' makes an entry Admin(not admin) in pg_shadow. Similarly, dropuser
deletes the same entry even with
> As user postgres I have run initdb. I create a user named
> Administrator via the createuser script. All goes well and I get the
> response CREATE USER.
> Then I try:
>
> psql -U Administrator template1
>
> and get the response:
> psql: FATAL: IDENT authentication failed for user "Administrat
On Thu, 2003-11-13 at 07:47, exciteworks hosting wrote:
> Is there an easy way to copy all DBs and users on a server to another
> server?
pg_dumpall is a good partner. If i am correct, you can also copy the
entire data directory, provided if both versions are same.
regards,
bhuvaneswaran
sign
> I have tried with pgpass but still it do
> es not work. I created the pgpass as per below:
>
Version? ~/.pgpass is supported since 7.3. Two more solutions are:
1) Set PGPASSWORD variable to avoid pg_dump asking for password
2) Set connection as trust in pg_hba.conf
regards,
bhuvaneswaran
rega
> [EMAIL PROTECTED]:database $
>
=> \set PROMPT1 '[EMAIL PROTECTED]:%/ $' -- Refer psql manual for details
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomai
> I get an error stating there is no such directory. The question is, how
> do I get the postgres bin created?
I suppose, you have installed it from binary rpm. By default, packages
will be installed in /usr/bin/. If you wish to have postgres commands in
seperate directory, you might require to re
> I don't really understand this. How to put password in ~/.pgpass. What
> changes do I need to do on the script? How do I access to the password
> to authenticate?
Follow the below steps to automate your backup process.
bash$ echo your_host:5432:your_user:your_db:your_pass > ~/.pgpass
bash$ chmo
> I would appreciate if some one could help me how to take a single table
> back up in postgres 7.2.3.
$ pg_dump -h hostname dbname -t tablename -uf filename.sql
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 6: Have you searched our list arc
> I have 7.2.3 postgres database running. how to find that the multi-byte
> is enabled or not for my database.
You should have used --enable-multibyte option during configure. If you
had, you can use 'pg_config --configure' to ensure it.
regards,
bhuvaneswaran
---(end o
> SELECT * FROM Hauptantrag WHERE (select datenfeldname from datenexport)
> > (select datum_von from datenexport) AND (select datenfeldname from
> datenexport) < (select datenexport.datum_bis from datenexport) limit 10;
It is not correct. You have not defined the condition between hauptantrag
&
> does anybody know the internal pg_ tables that has table/column
> definitions defined (similar to user_tab_columns in oracle)
pg_class for tables.
pg_attribute for columns.
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 3: if posting/readin
Hi,
This is my second post.
I am using postgresql 7.3.2 on redhat linux 7.3.
Where does postgresql store tg_op and tg_when details for a trigger? If i
am right, it is not in pg_trigger catalog.
TIA.
regards,
bhuvaneswaran
---(end of broadcast)---
psql=> \o filename.txt
psql=> select query;
psql=> \o
regards,
bhuvaneswaran
On Tue, 9 Sep 2003, Marvin wrote:
> Hi,
> There is a way to export the result
> of a query into an external DBF or TXT table?
>
> Thank you,
>
>
> MAGO
---(end of broadcast)--
> Whatever version of postgresql you WERE running is the same version you
> now need to BE running. I.e. if you were running 7.3.x, you should
> download 7.3.3 (or 7.3.4 if it's ready to go yet) and use THAT to get your
> database up and running. Postgresql won't run databases from different
>
> ERROR: stat failed on file '$libdir/plperl': No such file or directory
> createlang: language installation failed
Locate the file plperl.so and create the language with appropriate -L
option. Moreover, it may be solved by re-compiling. Before re-compling
instead of blindly giving --with-per
> > LISTEN/NOTIFY is yet another SQL. We can write a rule on an event and let
> > it notify. On the other hand, we can have a while(1) process which keeps
> > listening for that notification ie.. event. Once the event is occured, the
> > listening process would be notified. The listening process
> yes.
> simply execute LISTEN ; on the one side and then
> an NOTIFY on the other side. on the next query
> you'll see the notify. (you can easily try it w/ pgsql)
>
> but i currently dont know, if you can receive notifies in php ...
> that's what i'm really interested in ...
LISTEN/NOTIFY i
> 1) create one user with password and all Grant on Database. it is a admin
> user
The below steps would help:
$ su - postgres
$ createuser your_user
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
Use GRANT
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?
Add a timestamp field and set the default value as now(). If you wish to
maintain similar value during update, a before trigger could help.
regards,
bhuvaneswaran
---(end of broadcast)-
> work=# ALTER TABLE rdu ADD CONSTRAINT rdu_finish_time CHECK ((start_time <=
> finish_time) OR finish_time IS NULL);
> ERROR: AlterTableAddConstraint: rejected due to CHECK constraint
> rdu_finish_time
I can say that the field, finish_time have the values which conflict with
the check constrai
Hi,
In the first place, do we have any document which list the points to be
considered while upgrading to 7.3.2, other than HISTORY and
http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3 ?
Since in 7.3.2 the default timestamp is without timezone, the below
command fails:
# CREATE TABLE
> I'm using PostgreSQL 7.0.3.
> I'm doing vacuumdb in my database every night to repair it. But now I have a
> problem. I'm looking in /var/lib/pgsql/data/base/ for the tables length and
> the primary keys of the tables are not cleaned and is increasing evey day.
> What can I do to clean it?
> Than
> Could anybody help on how to compile the contribs?
>
> I've to copy them anywhere?
> How I do it?
>
The README in corresponding contrib module must be of much help. If not,
get back with the name of contrib module which you have tried.
regards,
bhuvaneswaran
---(end
> > Can you able to give some test cases? Here i have tried, but unable to
> > detect deadlock.
>
> Not a complete or tested example, but:
> create table a (a int primary key);
> create table b ( b int references a);
> insert into a values (1);
> insert into a values (2);
> Transaction 1: begin;
> If you're using foreign keys on the table that you're inserting into it's
> possible that it's waiting on another transaction doing an insert to the
> same key or on a change to the referenced table.
Can you able to give some test cases? Here i have tried, but unable to
detect deadlock.
BTW
> Hello,
>
> is there a way to display created rules in psql environment?
>
> Regards
> Nat
No \d option. But can get it from pg_rules system view. It contains the
definition as well.
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 5: Have y
35 matches
Mail list logo
