Re: [ADMIN] Deleting old files from pgsql_tmp

John Barham wrote: > Is it safe to delete old files created in pgsql_tmp? I ask because a > rogue query created almost 800 GB of temporary files and I would like > to reclaim that disk space. The query was killed (using kill -9 which > I know is not the right thing to do...) so did not get the ch

Re: [ADMIN] How to start postresql db server as a administrator on windows platform?

You really need to run PostgreSQL as an unprivileged user. The database server needs to serve as the *only* interface between processes accessing information stored by the server and that stored information. With the database user being an unprivileged process, you would be protected in case th

[ADMIN] Deleting old files from pgsql_tmp

Is it safe to delete old files created in pgsql_tmp? I ask because a rogue query created almost 800 GB of temporary files and I would like to reclaim that disk space. The query was killed (using kill -9 which I know is not the right thing to do...) so did not get the chance to clean up after itse

[ADMIN] Backup/Restore Views

What is the most simple way to backup and restore only views? Randall ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Pre-allocation of space: a business rationale

On Wed, Nov 02, 2005 at 10:48:00PM -0500, Tom Lane wrote: > "Bath, David" <[EMAIL PROTECTED]> writes: > > C) I want to avoid the possibility of uncontrolled growth of luser data > >blowing disk leading to stoppage of 24x7 data. > > You put the luser data and the critical data into separate tab

Re: [ADMIN] pg_dump and truncate

On Thu, Nov 03, 2005 at 11:43:37AM -0500, Colton A Smith wrote: > Hi: > > While pg_dump is dumping my database, I find that when I try to truncate > a table the query hangs. Is that the expected behavior? What if I try > to drop a table? Will that hang as well? Yes. dump grabs an AccessShare

Re: [ADMIN] Error:PG_DUMP relation pg_user does not exist

Fred Pope <[EMAIL PROTECTED]> writes: > I am running Postgresql 7.4.7. on RedHat ES-64 version 4 on a > Dual-Opteron Dual Core system. > I am having problems with the pg_dump command due to improper > initialization of the Database cluster on RH ES 4. Yeah, this is a known problem in some earli

[ADMIN] Help to restore my database please

thanks for your help to use postgersql. I am a beginner , i've just installed postgres with the windows installer. Before, i was using cygwin. My question is: how can i restore my old database (save with a .out extension)? I usually used the cygwin shell to save or restore my database. With

[ADMIN]

Hello, I'm trying to make a copy of a database using the following syntax: pg_dump -v -Fc -b cert | pg_restore -v -d prodcopy The output looks good until it the following: pg_dump: socket not open pg_dump: SQL command to dump the contents of table "casedocument" failed: PQendcopy() failed. pg_dump

[ADMIN] filesystem permissions and security

Hi, According to the manual from 7.3 onwards, PostgreSQL should be installed thusly:   $ ./configure   $ gmake   $ su   # gmake install   # adduser postgres   # mkdir /usr/local/pgsql/data   # chown postgres /usr/local/pgsql/data   # su - postgres   $ /usr/local/pgsql/bin/initdb -D /usr/local/pgs

[ADMIN] How to start postresql db server as a administrator on windows platform?

Hi there.. First, I'm a begginer to PostgreSQL. please, Don't fool me too much. ;-) As you see the title of this post, I'd like to know how to start postresql db server as a administrator of MS-windows os. (I'm trying not to run as a service.)Yes, I already know that according to th

Re: [ADMIN] UNIQUE KEY with null value...

there are answers why it is that, here is how you can surround the problem you can create the unique index after you create the table, something like CREATE TABLE test ( id integer not null primary key, id_uni integer not null, cod integer, name varchar(40)); CREATE UNIQUE INDEX test_id_uni_cod

[ADMIN] use Navicat PostgreSQL GUI to import Access data

Navicat for PostgreSQL is a PostgreSQL GUI management tool features an intuitive interface and provides a set of useful tool to create reports, backup/ restore, import/ export data, Synchronize database and connect to remote PostgreSQL server, etc.   Navicat supports the latest PostgreSQL version

[ADMIN] pg_dump and truncate

Hi: While pg_dump is dumping my database, I find that when I try to truncate a table the query hangs. Is that the expected behavior? What if I try to drop a table? Will that hang as well? Thanks as always! ---(end of broadcast)--- TIP 1: if

[ADMIN] Error:PG_DUMP relation pg_user does not exist

I am running Postgresql 7.4.7. on RedHat ES-64 version 4 on a Dual-Opteron Dual Core system. I am having problems with the pg_dump command due to improper initialization of the Database cluster on RH ES 4. The initial symptom was visible on execution of the command: pg_dump mydatabase > /tmp

Re: [ADMIN] subscribe

Geoffrey wrote: subscribe Sorry, not enough coffee yet -- Until later, Geoffrey ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[ADMIN] multiple postmasters on red hat cluster suite

We are going to use the red hat cluster suite for a database solution and would like to know if anyone has attempted (or knows if it's possible) to have multiple postmasters running on separate nodes of the cluster suite. Here's the specifics: 2 node cluster, 5 postmasters on each node, 10 dat

[ADMIN] subscribe

subscribe -- Until later, Geoffrey ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org