> 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
On Tue, Jun 17, 2003 at 10:09:04AM +0530, Anagha Joshi wrote:
>
(qestion in subject ...)
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 n
Title: Can the frontend get notifications from the postgres server?
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> mdu=# alter user raju with encrypted password 'raju'; ALTER
>> USER mdu=# select passwd from pg_shadow where usename='raju';
>> passwd
>> -
hello,
About view locks, i know watch the pg_locks at v7.3.
but using v7.2.1 on linux,
how do i view and release table or row locks?
thank you!
yangming
[EMAIL PROTECTED]
2003-06-17
---(end of broadcast)---
TIP 7: don't forget
Thanks for your help!
> Alex Pollock
> WFSC Data Services District
> Database Administration
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 4:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] transactions included in hot
[EMAIL PROTECTED] wrote:
> Does pg_dump include all transactions that are committed before the hot
> backup is finished in the database backup? If not, what transactions are
> included in the hot backup?
All transactions at _start_ of backup, per database.
--
Bruce Momjian
Does pg_dump include all transactions that are committed before the hot
backup is finished in the database backup? If not, what transactions are
included in the hot backup?
Thanks!
Alex Pollock
WFSC Data Services District
Database Administration
---(end of broadcast)---
Raj Mathur <[EMAIL PROTECTED]> writes:
> mdu=# alter user raju with encrypted password 'raju';
> ALTER USER
> mdu=# select passwd from pg_shadow where usename='raju';
>passwd
> -
> md5ef70c430d5ed1ed52bd2ae960bb8ebe4
> (1 row)
> mdu=# create use
On Fri, 13 Jun 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Yes, you can do it. All you have to do is create four seperate accounts
> > for it to run under (pgsql1, pgsql2, pgsql3, pgsql4) and then in each of
> > those accounts, set up a different PGDATA value and ini
Markus Bertheau <[EMAIL PROTECTED]> writes:
> PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
> How do I get rid of these huge files
"rm" will do fine, assuming that you are certain the creating backends
aren't around anymore.
> and how do I prevent them from being created again?
A
At 17:24 16.06.2003, Jodi Kanter said:
[snip]
>If I'm using transactions (not autocommit), are sequences atomic?
Yes
>In other words, after inserting a record to a table that
>uses sequence A, am I guaranteed that select last_value on
>sequence A is ato
On Mon, 16 Jun 2003, Christian Brosig wrote:
> I use postgres now for about 1 Year and i am really happy with postgres
> (7.2).
>
> I use Linux as database server and pgAdmin as frontent.
>
> Last week I set up a new server. Included in the new linux distribution
> is also a newer version of postg
Hi,
I use postgres now for about 1 Year and i am really
happy with postgres (7.2).
I use Linux as database server and pgAdmin as frontent.
Last week I set up a new server. Included in the new linux
distribution is also a newer version of postgres (7.3.2)
I used pg_dump to export a
[EMAIL PROTECTED] 6221984]# pwd
/var/lib/pgsql/data/base/6221984
[EMAIL PROTECTED] 6221984]# ls -lh --sort=size | head -10
total 9.9G
-rw---1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10742.0
-rw---1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10749.0
-rw---1
Hello,
I am building an rpm for Mitle SME (a scaled down redhat 7.3) and
have all functions working except:
I need to have the rpm when installed create a database and a
user with privilege to that database. These commands are easy
enough in general...
# service postgre
Hello,
> BTW -- this is pretty easy with the RPMs (I think you said you were on
> RedHat). Just make a symlink to the init script. Call it 'pg2'
>
> Then put the port and pgdata definitions in /etc/sysconfig/pgsql/pg2
No, I am on SuSE but don't using the RPMs (maybe on RedHat it will be
bette
Hello,
> BTW -- this is pretty easy with the RPMs (I think you said you were on
> RedHat). Just make a symlink to the init script. Call it 'pg2'
>
> Then put the port and pgdata definitions in /etc/sysconfig/pgsql/pg2
No, I am on SuSE but don't using the RPMs (maybe on RedHat it will be
better) be
On Mon, Jun 16, 2003 at 11:24:28 -0400,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> If I'm using transactions (not autocommit), are sequences atomic?
Yes.
> In other words, after inserting a record to a table that
> uses sequence A, am I guaranteed that select last_value on
> sequence A is atomi
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> Using Postgresql 7.2.3 on Linux, is there an easy way to
>> transfer user passwords from one database to another?
Tom> You could look at what pg_dumpall --globals-only does.
Tried t
[EMAIL PROTECTED] 6221984]# pwd
/var/lib/pgsql/data/base/6221984
[EMAIL PROTECTED] 6221984]# ls -lh --sort=size | head -10
total 9.9G
-rw---1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10742.0
-rw---1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10749.0
-rw---1
Hello,
is it possible, to backup all users with their grants to the tables or the
database?
Thank you
Daniel Seichter
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Title:
If I'm using transactions (not autocommit), are sequences atomic?
In other words, after inserting a record to a table that
uses sequence A, am I guaranteed that select last_value on
sequence A is atomic, and cannot be interfered with by other
transacti
Raj Mathur <[EMAIL PROTECTED]> writes:
> Using Postgresql 7.2.3 on Linux, is there an easy way to transfer user
> passwords from one database to another?
You could look at what pg_dumpall --globals-only does.
> I have an application that creates data (and users) centrally and then
> distributes t
Erhm, the last line of the earlier mail should read:
I tried an "update pg_shadow set passwd=... where usename=..." but
that doesn't do the trick: Postgresql does not authenticate the user.
Regards,
-- Raju
--
Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/
GPG: 78
Hi,
Using Postgresql 7.2.3 on Linux, is there an easy way to transfer user
passwords from one database to another?
I have an application that creates data (and users) centrally and then
distributes them to remote databases. I can transfer everything else,
but do not know how to transfer MD5 pass
On Mon, Jun 16, 2003 at 15:45:28 +0530,
Anagha Joshi <[EMAIL PROTECTED]> wrote:
> Hi All,
> I mean to say
> Can I know the time when particular row is inserted into the table? i.e.
> timestamp of insertion of row into the table.
That isn't precise. What do you mean when you say it is insert
"Anagha Joshi" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I mean to say
> Can I know the time when particular row is inserted into the table? i.e.
> timestamp of insertion of row into the table.
Is not clear what you want:
# begin transaction;// 10:00:00 AM
[ 3 minutes of delay ( com
Hi All,
I mean to say
Can I know the time when particular row is inserted into the table? i.e.
timestamp of insertion of row into the table.
Pls. note this.
Thx,
Anagha
-Original Message-
From: Mendola Gaetano [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 2:05 PM
To: Bruno W
"Bruno Wolff III" <[EMAIL PROTECTED]> wrote:
> Mendola Gaetano <[EMAIL PROTECTED]> wrote:
> > "Bruno Wolff III" <[EMAIL PROTECTED]> wrote:
> > > You still may not want to use timeofday even for long transactions.
> > > It depends on what the data really means to you.
> >
> > The OP was looking f
On Mon, Jun 16, 2003 at 10:34:46 +0200,
Mendola Gaetano <[EMAIL PROTECTED]> wrote:
> "Bruno Wolff III" <[EMAIL PROTECTED]> wrote:
> > You still may not want to use timeofday even for long transactions.
> > It depends on what the data really means to you.
>
> The OP was looking for a way to know
"Bruno Wolff III" <[EMAIL PROTECTED]> wrote:
> You still may not want to use timeofday even for long transactions.
> It depends on what the data really means to you.
The OP was looking for a way to know the time of a row insertion,
not the time of the transaction inside where the row was inserted
32 matches
Mail list logo
