localhost[/usr/local/pgsql/data]# psql test dbuser
Password:
psql: The Data Base System is shutting down
localhost[/usr/local/pgsql/data]#
-
I am getting weird DB shutdowns. Anybody experience this before ? Any ideas
welcome. What could this
Hi,
Can I know how many session I have?
Ex: mysql
SHOW PROCESSLIST;
oracle
select from v$_sessons;
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Colleagues,
How do I get the postgresql statistics? I would like to know queries
per second etc.
The stats_start_collector variable is on, and I can see the
stats collector process running. But how do I query it?
Thanks a lot for any input.
--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
2:5005
ppropriate
>> > subscribe-nomail command to [EMAIL PROTECTED] so that your
>> > message can get through to the mailing list cleanly
By the way this advice does not work. Majordomo says:
The command mode "nomail" is invalid.
--
Victor Sudakov, VAS4
.
--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
2:5005/[EMAIL PROTECTED] http://vas.tomsk.ru/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
sions and other information in this message represent the
> opinion of the sender and do not necessarily represent or reflect the views and
> opinions of Ferring.
> **
>
>
> ---(end of b
eq'::text)
name | text|
== cut here =
Voila! pg_restore will now return an error on trying to execute
SELECT pg_catalog.setval('sometable_id_seq', 4, true);
because this sequence has not been created either explicitly or implicitly!
It is 100% reproducible on post
ce of the postmaster kills the
previous instance's UNIX socket. Is this how it should be -- and if so,
are there any pg_ctl options I can pass in to make it simply not create
the UNIX sockets altogether, so that only network operations are
supported? AT the moment, I am doing admin access though
On Thu, 27 Jan 2005, Victor Danilchenko wrote:
> Hi,
>
> I am trying to set up a database server with multiple DB
>clusters, so that in each cluster a number of users have their own
>database each, with passwordless access (we can trust the network
>security in our
's supposed to return the actual userid
instead of 'OTHER'. Any ideas about what's going wrong?..
On Thu, 27 Jan 2005, Victor Danilchenko wrote:
>On Thu, 27 Jan 2005, Victor Danilchenko wrote:
>
>> Hi,
>>
>> I am trying to set up a database s
On Thu, 27 Jan 2005, Bruno Wolff III wrote:
>On Thu, Jan 27, 2005 at 12:22:06 -0500,
> Victor Danilchenko <[EMAIL PROTECTED]> wrote:
>>
>> the solution was in disabling the 'result:encrypt' option
>> (setting it to 'no') in the /etc/i
[]´s
Victor Hugo P.Clemente
Brazil
2010/8/5 Silvio Brandani :
> Hi,
>
> a query on our production database give following errror:
>
>
> 2010-08-05 10:52:40 CEST [12106]: [278-1] ERROR: out of memory
> 2010-08-05 10:52:40 CEST [12106]: [279-1] DETAIL: Failed on request o
Mark,
You could use LDAP to? that?
I use LDAP + apache
[]´s
Victor Hugo
2010/8/5 Tom Lane :
> "Mark Steben" writes:
>> I would like to set up a facility that enforces password changes for roles
>> After a predefined period (30 days for instance) when logging int
Correcting I use LDAP + postgresql
2010/8/5 Victor Hugo :
> Mark,
>
> You could use LDAP to? that?
>
> I use LDAP + apache
>
> []´s
> Victor Hugo
>
>
>
> 2010/8/5 Tom Lane :
>> "Mark Steben" writes:
>>> I would like to set up a
Gentlemen, I need a help ..
I have a table X in a bytea field and this field stores images, I need
to save that image and cryptogram qnd I am displaying the information
I need to decrypt this file, could someone help??
--
[]´s
Victor Hugo
--
Sent via pgsql-admin mailing list (pgsql-admin
Hi,
Someone uses pgExpress Driver v4.11 with postgresql 8.4.4?
--
[]´s
Victor Hugo
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
-includedir=/opt/PostgreSQL/8.4/include
I've installed postgresql 8.4.4.
This may be due to lack of a library of Linux?
Tk´s !
[]´s
victor hugo
log below
===
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works..
Hi,
Do you compile your postgresql with clause --with-ldap ??
Configuration pg_hba.conf:
hostbase_central all 0.0.0.0 0.0.0.0 ldap
"ldap://172.16.10.2/dc=mydomain,dc=com;uid=;,ou=Users,dc=mydomain,dc=com";
Verify now...
See you soon.
[]´s
victor hugo
7;t want to use one-click installer, I just want to work with
unzipped binaries.
Thanks in advance
Victor
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
the master and slave?
Thanks.
- Victor Tan
he
time of backuping routine start.
I want to be sure, that nothing additional will get into dump after I'll
start pg_dump.
Is this possible? Or, may be, such behaviour is on by default (I
didn't find anything concerning my problem in the docs about pg_dump).
Thank you.
--
Victor Yego
design except for the field you'd like to
change, than copy all data into new table, drop old one and rename new one.
>
> Thanks in advance.
--
Victor Yegorov
pgp0.pgp
Description: PGP signature
unsubscribe from the list, click here'
Thats it!
--
Victor Yegorov
pgp0.pgp
Description: PGP signature
t;=
> end_time) OR end_time IS NULL);
> ALTER
> 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
Perhaps you have some rows
an the dump of database every day... and only two day ago, I
receive this error.
So.. In base a this I write to you to ask if everyone have any idea
about this problem ??
thanks and attentive.
--
--
Victor Hugo dos Santos
Linux Counter #224399
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
===
attentive.
--
--
Victor Hugo dos Santos
L
4 11:59 /tmp/public-files.sql
$ sudo cat /tmp/public-files.sql | wc
2580840 59359163 311685729
=
but, I'm dowloading the 64bit image now and after I install it in a
Virtual Machine to try.
thanks and attentive to others commentaries.
--
--
Victor Hugo dos Santos
Linux Counter #224
On Tue, Jan 4, 2011 at 12:02 PM, Victor Hugo dos Santos
wrote:
[...]
> but, I'm dowloading the 64bit image now and after I install it in a
> Virtual Machine to try.
I'm a stupid !! :(
I can't restore the same DB from 32bit in 64bits !!!
for this, should be export first in
On Tue, Jan 4, 2011 at 1:05 PM, Tom Lane wrote:
> Victor Hugo dos Santos writes:
>> any idea ???
>
> It looks like a corrupted-data problem from here. You need to isolate
> and delete the bad row(s).
hello
any sugestion about how found and delete the bad row(s) ??
thanks
On Tue, Jan 4, 2011 at 1:05 PM, Tom Lane wrote:
> Victor Hugo dos Santos writes:
>> any idea ???
>
> It looks like a corrupted-data problem from here. You need to isolate
> and delete the bad row(s).
Hello again...
this is very, very strange !! :D
(sorry for long message,
30 matches
Mail list logo
