[ADMIN] Locks on Tables

Hi How can I see if there is a lock on a table or row of a table? -- Cheers Tony$B!#(B - _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

Re: [ADMIN] Building binary...

From: Gaetano Mendola [mailto:[EMAIL PROTECTED]] I'm trying to build the binaries of Postgresql 7.2 for Redhat 7.1 This was the resoult: (Failed dependencies) I tried to find a new binary for gettext without result, so I donwloaded the source, I installed the version 0.10.40:

[ADMIN] Why my /var/log/pgsql is empy

Why on my Red Hat 7.2 box and Postgres 7.1.3 /var/log/pgsql file is empy and has executable rights ? °° su www.tim.it puoi consultare il catalogo di tutti i nuovi telefonini TIM.

Re: [ADMIN] Why my /var/log/pgsql is empy

Simeone, Mario wrote: Why on my Red Hat 7.2 box and Postgres 7.1.3 /var/log/pgsql file is empy and has executable rights ? In /etc/postgresql/postgresql.conf you must have a debug_level set to 0 and log some options like this example: debug_level = 0 log_connections = on log_pid = on

[ADMIN] Error in ODBC

I update PostgreSQL toversion 7.1.3 and I try to conect with ODBC version 7.01.00.09 and return a error : fails in the test of connection reason error in the initialization provider %1 Its problem in my ODBC ? or in my update ? Denilson Guedes DuarteProvedor de Internet da Fronteira

[ADMIN] pg_dumpall and pg_dumps

Hai, Pg_dumpall is giving hard time in restoring the database.I opened the dump and checked it . There are lot of problem in connectin and reconnecting and plpgsql language call handler. Finally I have decided to use pg_dump. It has also got the following bugs in it. It is not setting the

[ADMIN] \connect case-folding change maybe not such a good idea

Peter, I'm having second thoughts about this change: 2001-09-02 19:52 petere * src/bin/psql/command.c: Parse the arguments of \connect as SQL identifiers, so that they expose the expected behavior in mixed-case situations. bug report from James Pattie,

Re: [ADMIN] pg_dumpall and pg_dumps

[EMAIL PROTECTED] (Srinivasa Rao Chava) writes: Pg_dumpall is giving hard time in restoring the database.I opened the dump and checked it . There are lot of problem in connectin and reconnecting and plpgsql language call handler. This is not helpful; if you want us to fix things you're going

Re: [ADMIN] pg_dumpall and pg_dumps

On Thu, 21 Feb 2002 12:53:59 -0500 Tom Lane [EMAIL PROTECTED] wrote: TL There are known problems in reloading 7.1 dumps into 7.2 if you use TL mixed-case user names or database names; might that be the source TL of some of your problems? Are there other problems? while you're at it, there are

Re: [ADMIN] pg_dumpall and pg_dumps

Simone Tellini [EMAIL PROTECTED] writes: while you're at it, there are 2 other problems I've always experienced with pg_dump/pg_dumpall: 1. it fails to restore databases owned by users who aren't allowed to create databases: the dump contains a CREATE USER x NOCREATEDB line at the

Re: [ADMIN] pg_dumpall won't work?

On Thu, 07 Feb 2002 12:52:26 -0500, Tom Lane [EMAIL PROTECTED] wrote: Joel Mc Graw [EMAIL PROTECTED] writes: I tried to run pg_dumpall and I got strdup: failed to allocate memory. I tried to run it again and I get a segmentation fault. Strange. Can you provide a debugger backtrace from the

Re: [ADMIN] pg_dumpall won't work?

Joel Mc Graw [EMAIL PROTECTED] writes: Tom, I'm afraid I'm not quite the guru I'd like to be; can you (or anyone) provide guidance on getting a debugger backtrace from the segfault? Find the core file (if there isn't one, maybe you need ulimit -c unlimited) and do gdb

[ADMIN] Help on Trugger/Function

I am new to postgresql -- I am trying to create a trigger on a table -- I get this error on the function ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Recognized languages are sql, C, internal, and created procedural languages. Here is my function that I get this

Re: [ADMIN] pg_dumpall and pg_dumps

On Thu, 21 Feb 2002 13:44:03 -0500 Tom Lane [EMAIL PROTECTED] wrote: TL 2. you can't specify username and password on the command line: this TL makes it impossible to backup automatically all the databases from a TL cron script if you use password authentication, for instance. TL

Re: [ADMIN] problem with postgresql7.2 installation

At 08:09 AM 2/15/2002 , Srinivasa Rao Chava wrote: Hi, I'm trying to install postgresql7.2 on susOS. When I used gmake command to build it, it is giving the following error. /usr/ucb/cc: language optional software package not installed You need to install the Sun Workshop compiler suite, or the

[ADMIN] Running postgresql problem??

I have a problem running postgresql Specifically, this is the error that Iget: csil-sunb23|/usr/dcs/csil-projects/cs411/cs411g3/postgres/bin|[142]% postmaster -B 32 -N 16 -D /usr/dcs/csil-projects/cs411/cs411g3/postgres/data FATAL 1: configuration file `postgresql.conf' has wrong permissions

Re: [ADMIN] \connect case-folding change maybe not such a good idea

I said: I think the wisest course may be to revert to the 7.1 \connect behavior There is another possibility, which is to migrate to the new behavior over time. I like having pg_dump quote the names in \connect, because that gives us a shot at working with names that have embedded spaces. We

[ADMIN] search engine

How can search engine search through millions of records in just a few seconds? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

[ADMIN] copy notice

Hi , I load a | delimited text file into a table using the following command : copy table_name from '/usr/local/pgsql/table_name.dat' using delimiters '|'; and get this notice for each row : NOTICE: copy: line 21579, CopyReadNewline: extra fields ignored but the rows are loaded succesfully,

[ADMIN] postgres backend processes

Hi! I'm accessing a database using JDBC. My Java code for a query typically looks like: Statement sta = con.createStatement(); sta.executeQuery( SELECT * FROM TABLE ); For some reason, the postgres daemon that gets forked on the DB server (Solaris 2.6,

[ADMIN] Set a quota of File System for Database Users

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have to setup an Apache+PHP+Postgresql with multiple users and each one with just a quota of space of my File System. Could i limit each user trought Pgsql, or i should create a DB for each one. Anybody knows if it is posible. Tanks ..

Re: [ADMIN] Problem

Raghav wrote: Hi!! I am trying to install Postgresql-7.2 on Windows 2000. As per requirement I have downloaded the Cygwin and Cygipc packages. I have also been succesful in starting ipc-daemon service. But when I am giving './configure' I am geting following message loading cache

Re: [ADMIN] Help on Trugger/Function

On Thu, 14 Feb 2002, Pam Wampler wrote: I am new to postgresql -- I am trying to create a trigger on a table -- I get this error on the function ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Recognized languages are sql, C, internal, and created procedural

[ADMIN] psql error

I'm new with postgress datbase.. I have started correctly postmaster, I created a database primo ... Now when I try to start psql primo I receive the following error psql : FATAL 1: cannot create init file .//base/primo/pg_internal.init.1179 Regards ---(end of

Re: [ADMIN] FATAL 1: configuration file 'postgresql.conf' has wrong

Andrey Romanchenko wrote: hi all! when I attempt to start postgresql i see error message FATAL 1: configuration file 'postgresql.conf' has wrong permissions -rw--w--w-1 postgres postgres 3148 Feb 19 11:19 postgresql.conf Uh, quite a big. Try: chmod og-w

Re: [ADMIN] psql error

Gtrica wrote: I'm new with postgress datbase.. I have started correctly postmaster, I created a database primo ... Now when I try to start psql primo I receive the following error psql : FATAL 1: cannot create init file .//base/primo/pg_internal.init.1179 Regards What permissions on

[ADMIN] Problem/Question

Hi, I'm at my wits end with this one. I'm using PostgreSQL 7.1.3 on Solaris 2.8. I want to create two databases in the same postmaster. I did my initdb and started the postmaster. I set two environment variables, one for each database's location. Next: initlocation -D DB1 initlocation -D

Re: [ADMIN] Set Passsword for existing User

On Sun, 17 Feb 2002, Andreas Hierling wrote: I know, this should work with ALTER USER..., But when I set the password this way, i´m still able to gain unrestricted access without a password. When setting a Password by creating the user, there´s no such problem. I´m working with PostgreSQL

Re: [ADMIN] Problem/Question

On Wed, 20 Feb 2002, Judy Jecelin wrote: Hi, I'm at my wits end with this one. I'm using PostgreSQL 7.1.3 on Solaris 2.8. I want to create two databases in the same postmaster. I did my initdb and started the postmaster. I set two environment variables, one for each database's

Re: [ADMIN] Building binary...

Gaetano Mendola writes: root@XXX rpm --rebuild postgresql-7.2-1PGDG.src.rpm Installing postgresql-7.2-1PGDG.src.rpm error: failed build dependencies: gettext = 0.10.36 is needed by postgresql-7.2-1PGDG Try rpm --rebuild --nodeps postgresql-7.2-1PGDG.src.rpm -- Peter Eisentraut [EMAIL

Re: [ADMIN] psql error

Gtrica [EMAIL PROTECTED] writes: I'm new with postgress datbase.. I have started correctly postmaster, I created a database primo ... Now when I try to start psql primo I receive the following error psql : FATAL 1: cannot create init file .//base/primo/pg_internal.init.1179 It looks to me

Re: [ADMIN] \connect case-folding change maybe not such a good idea

Tom Lane writes: I said: I think the wisest course may be to revert to the 7.1 \connect behavior There is another possibility, which is to migrate to the new behavior over time. I like having pg_dump quote the names in \connect, because that gives us a shot at working with names that

Re: [ADMIN] About groups in postgres

1) Is there any way of asking postgres the groups a user account belongs to? You can figure this out, but I don't know of a nice clean way of doing it. Check out the pg_group table. There's got to be a 'value in array' type function that could make that an easy select. 2) Let's suppose

[ADMIN] What does PGDG stand for in postgresql-7.2-1PGDG.rpm

Hi Can someone please tell me what the PGDG stands for in postgresql-7.2-1PGDG.rpm -- Cheers Tony$B!#(B - _ Do You Yahoo!? Get your free @yahoo.com address at