Re: [ADMIN] adminpack installed?

Le 13/12/2010 21:41, Fred Parkinson a écrit : > Thanks again for your great help. > > I ran adminpack.sql in the query window and it returned 'success'. > > I actually did read the complete message and it was (slightly) vague > enough that I thought there was a chance it didn't just apply to th

Re: [ADMIN] 8.4 restore parallel

Le 13/12/2010 21:42, paulo matadr a écrit : > [...] > I made an backup of database 8.3 > test.dmp > and tested restore in (8.4.5) using parallel > pg_restore -d xxx -n yyy -t -j 3 < test.dmp > > And give error: > pg_restore: [custom archiver] cannot reopen stdin > pg_restore: [archiver

Re: [ADMIN] log_file_mode

Le 13/12/2010 21:03, Dinesh Bhandary a écrit : > Hi All - Is log_file_mode parameter available for postgres 9.0 only? Ran > into a bit of problems with log permission and came across a new GUC > "log_file_mode". But I could not seem to find much docs on it and I am > not sure if it is production re

[ADMIN] 8.4 restore parallel

Hi all, I made an backup of database 8.3 test.dmp and tested restore in (8.4.5) using parallel pg_restore -d xxx -n yyy -t -j 3 < test.dmp And give error: pg_restore: [custom archiver] cannot reopen stdin pg_restore: [archiver] worker process failed: exit code 1 Why not working? Reg

Re: [ADMIN] adminpack installed?

Thanks again for your great help. I ran adminpack.sql in the query window and it returned 'success'. I actually did read the complete message and it was (slightly) vague enough that I thought there was a chance it didn't just apply to the windows installer. Thanks for your expert help. Fred

Res: [GENERAL] Res: [ADMIN] Cluster with LATIN1 and UTF-8

Solved tnks... createdb -E LATIN1 -O -T template0 --lc-collate=pt_BR --lc-ctype=pt_BR Paulo De: Osvaldo Kussama Para: paulo matadr Enviadas: Segunda-feira, 13 de Dezembro de 2010 16:14:36 Assunto: Re: [GENERAL] Res: [ADMIN] Cluster with LATIN1 and

[ADMIN] log_file_mode

Hi All - Is log_file_mode parameter available for postgres 9.0 only? Ran into a bit of problems with log permission and came across a new GUC "log_file_mode". But I could not seem to find much docs on it and I am not sure if it is production ready. Can patches be applied to older version of post

Re: [ADMIN] adminpack installed?

Le 13/12/2010 18:28, Fred Parkinson a écrit : > New to managing postgresql, I hope my questions are not a burden to this > group, but I have another. > > I have installed version 8.4.5 of postgresql, 1.12.1 of pgadmin3. > > When I invoke pgadmin3 from a terminal prompt I get the message that

Re: [ADMIN] FOR SHARE permissions

On 12/11/10 7:47 PM, David Underhill wrote: I have two tables. One has a foreign key referencing a serial field in the other table. I've given INSERT privilege to a role other than the owner, but I still can't insert into the table containing the foreign key unless I grant the /owner/ of the

[ADMIN] adminpack installed?

New to managing postgresql, I hope my questions are not a burden to this group, but I have another. I have installed version 8.4.5 of postgresql, 1.12.1 of pgadmin3. When I invoke pgadmin3 from a terminal prompt I get the message that "The server lacks instrumentation functionsadminpack i

Re: [ADMIN] pgadmin3: can't locate server: what am I doing wrong?

Thank you for your quick and accurate reply. I logged in as root, picked the 'add a connection...' option you suggested and voila! The server is now visible to pgadmin3/root user. Thanks again, Fred >>> Guillaume Lelarge 12/13/2010 8:32 AM >>> Le 13/12/2010 17:20, Fred Parkinson a écrit : > I

Res: [ADMIN] Cluster with LATIN1 and UTF-8

I dont find way to create cluster... with example: psql -l teste1 |admin| LATIN1 teste2 | postgres | SQL_ASCII teste3| admin2| UTF8 -bash-3.1$ psql --ver

Re: [ADMIN] pgadmin3: can't locate server: what am I doing wrong?

Le 13/12/2010 17:20, Fred Parkinson a écrit : > I am a longtime user of postgersql, using it as a backend and using odbc to > connect and it has been an amazingly stable and useful database manager. > > Now, a longtime Windows user (disgruntled) I am trying to set up a > development platform on

[ADMIN] pgadmin3: can't locate server: what am I doing wrong?

I am a longtime user of postgersql, using it as a backend and using odbc to connect and it has been an amazingly stable and useful database manager. Now, a longtime Windows user (disgruntled) I am trying to set up a development platform on a local Suse Linux box which includes a local install o

Re: [ADMIN] Cluster with LATIN1 and UTF-8

Ciao Paulo, Il 13/12/10 14:22, paulo matadr ha scritto: Im try install postgres 9.0 on rhel and I try install cluster with 2 options of databases LATIN1 and UTF-8. It's possible? Yes it is. I suggest that you look at the "ENCODING" option for the CREATE DATABASE command: http://www.postgres

[ADMIN] Cluster with LATIN1 and UTF-8

Hi all, Im try install postgres 9.0 on rhel and I try install cluster with 2 options of databases LATIN1 and UTF-8. It's possible? Paulo

Re: [ADMIN] Two copies of Postgres with Graphical installer

Depending on you distribution you can install multiple versions of postgres at the same time, but normally this can be done only per major version. i.e. you can install 8.1, 8.4 and 9.0 in parallel, but not per minor version. gentoo e.g. does support this and calls it slotted installation. maybe y

Re: [ADMIN] Urgent -- Very HIGH memory usage on PostgreSQL server

On Sun, Dec 12, 2010 at 9:39 AM, savio rodriges wrote: > Hello Support, > > We are facing very HIGH memory utilization on postgreSQL server and need help. > > Below are details of PostgreSQL server, > > === > MemTotal:      81