-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 30 May 2004 09:44 pm, Paul Gimpelj wrote:
> If I connect to any database with psql I can see all the other databases in
> table pg_database under postgresql 7.2
>
> What happens if I delete all the rows from this table.
Well, similar questi
If I connect to any database with psql I can see
all the other databases in table pg_database
under postgresql 7.2
What happens if I delete all the rows from this
table.
you can simply:
select * from pg_group;
On Thu, 2004-02-12 at 08:09, Eric wrote:
> In PostGres, we can show all existing users by "\du".
> However, how to show all existing groups?
> Thanks
>
> ---(end of broadcast)---
> TIP 6: Have you searched ou
Ian Lipsky <[EMAIL PROTECTED]> writes:
> is there a way to tell when a database was created?
Nope, PG doesn't record that anywhere.
You could get an upper bound by looking for the oldest file mod time in
the database's files. This isn't completely reliable, but unless you're
in the habit of chan
[EMAIL PROTECTED] (Greg) writes:
> linux:~ # pg_restore -d ppr -U postgres -i baza.sql
> pg_restore: [archiver (db)] connection to database "ppr" failed:
> FATAL: IDENT authentication failed for user "postgres"
You can't use "-U" or similar switches when you've selected IDENT
authentication --- t
"angshumitra ghosh" <[EMAIL PROTECTED]> writes:
> Can anyone please tell me why postmaster is shutting down ? What all
> causes the SIGINT signal to be sent to postmaster that causes rollback of
> open transactions and disconnection of open connections ?
I suspect that you are doing something
[EMAIL PROTECTED] writes:
> I would not have wasted 1 hour and 22 minutes to fix this:
> tcpip_socket = true
FWIW, 7.5 will default to allowing local TCP connections ... but not
remote. Dunno whether that will make you happier. Default remote
connections would be a mighty hard sell, though, cons
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Frank Smith") would write:
> Hi
>
> ID:7
>
> I am running PostgreSQL 7.2.2 on Red Hat 9 and I am suffering a
> growing performance problem. The problem shows through a slowing of
> queries and an increase in the system CPU usage. Queri
[EMAIL PROTECTED] (Vasil Kolev) wrote:
> I'm working on a system that has 2 servers with postgresql, and a FC
> shared storage between them, where the database is stored. After
> some weeks of using google and reading lists, I've come to the
> conclusion, that there is no way (using F(L)OSS tools)
Jeff Boes wrote:
> I just discovered that the use of a much larger setting on vacuum_mem
> has a joyous effect on the throughput of VACUUM FULL for some of our
> tables. However, all of my maintenance scripts use "vacuumdb" (the
> command-line utility) instead of psql. How can I set vacuum_mem f
Title: No space left on device
Hi
I am using Postgres Database version 7.3.1.
I am getting following error when I am starting postmaster. I could not be able to start the postmaster.
Pl help me
Regard
Shiva Kumar
LOG: database system was shut down at 2005-02-03 05:35:03 GMTST
LO
is there a way to tell when a database was created? I've tried looking in
some of the postgres system tables but i didnt see any that looked like it
had a creation date.
I would have also looked at the date the data folder for the database was
created, but i didnt know which folder belonged to
I am facing some problem while using postgres (version 7.3.1)
On trying to execute a psql command from the postges interactive terminal
as user 'test' (which exists in the pg database), pgsql seems to be
crashing.
The postmaster log file contains the following -
Hi
ID:7
I am running PostgreSQL 7.2.2 on Red Hat 9 and I am suffering a growing
performance problem. The problem shows through a slowing of queries and
an increase in the system CPU usage. Queries that took less than 6
seconds clime to take more than 5 minutes and as the system is driven by
A
Nobody answered so far. I have cleared it for myself.
Ok, that was a security issue. I messed 2 accounts - Administrator and
Postgres. 2nd one has no rights to start postgres.
A bit strange for me, becose from shell the command 'postgres.exe' or
'postgres' was visible and was able to start it.
An
I just discovered that the use of a much larger setting on vacuum_mem
has a joyous effect on the throughput of VACUUM FULL for some of our
tables. However, all of my maintenance scripts use "vacuumdb" (the
command-line utility) instead of psql. How can I set vacuum_mem for the
duration of the v
Hello,
I'm working on a system that has 2 servers with postgresql, and a FC
shared storage between them, where the database is stored. After some
weeks of using google and reading lists, I've come to the conclusion,
that there is no way (using F(L)OSS tools) to use both databases R/W, or
even on
I would not have wasted 1 hour and 22 minutes to fix this:
# Connection Parameters
#
tcpip_socket = true
btw: The first time a co-worker enlightened me. The solution did not stick.
Thanks,
-Jimmy (6yr Java Developer)
Home: 770 565 4251
p.s. I always login as root!
-
Hi,
Frankly I don't know what should I do more. The problem is:
I've made a pg_dump from shell like that:
pg_dump -Upostgres -O -D -Fc --file=baza.sql
Copied the file to new server and from shell executed:
linux:~ # pg_restore -d ppr -U postgres -i baza.sql
The result is
pg_restore: [archiver (db
Hello,
I read online that Postgres 7.4.1 has the capability to do
hotbackups (equivalent to Hotbackups on Oracle). But am not able to find any
documentation which will help me set up one. Can you please point me to a
resource that I can use to set up hotbackups for Postgres 7.4.1 ?
On Wed, 11 Feb 2004, Christopher Browne wrote:
> A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jodi Kanter) wrote:
> > Do constraints effect performance significantly?
>
> They would be expected to provide a significant enhancement to
> performance over:
> a) Firing triggers,
>
21 matches
Mail list logo
