В Чтв, 03/06/2010 в 13:07 -0400, Greg Smith пишет:
> Vasiliy G Tolstov wrote:
> > In config file some in of this settings exists comment line like
> > "changes require restart". This is mean exactly restart or reload can do
> > this?
> >
>
> Run this:
>
> $ psql -c "select name,context from pg
On Thursday 03 June 2010 11:45, Tom Lane wrote:
> Kevin Kempter writes:
> > On Thursday 03 June 2010 11:18, Tom Lane wrote:
> >> Bizarre ... that command really oughtn't be invoking any non-builtin
> >> operator, but the OID is too high for a builtin. What do you get from
> >> "select 33639::rego
Al Eridani wrote:
> Is it possible to modify the size of pg_xlog? How? Where?
The size of each file within the directory, or the number of files
in the directory?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postg
Kevin Kempter writes:
> On Thursday 03 June 2010 11:18, Tom Lane wrote:
>> Bizarre ... that command really oughtn't be invoking any non-builtin
>> operator, but the OID is too high for a builtin. What do you get from
>> "select 33639::regoperator"?
> postgres=# select 33639::regoperator
> postgr
On Thursday 03 June 2010 11:18, Tom Lane wrote:
> Kevin Kempter writes:
> > pg_dump: Error message from server: ERROR: could not find hash function
> > for hash operator 33639
>
> Bizarre ... that command really oughtn't be invoking any non-builtin
> operator, but the OID is too high for a builti
Kevin Kempter writes:
> pg_dump: Error message from server: ERROR: could not find hash function for
> hash operator 33639
Bizarre ... that command really oughtn't be invoking any non-builtin
operator, but the OID is too high for a builtin. What do you get from
"select 33639::regoperator"?
Hi all;
I'm seeing these errors when running a pg_dump of the postgres database:
Running: [pg_dump --schema-only postgres > postgres.ddl]
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not find hash function for
hash operator 33639
pg_dump: The command was: SELECT
Vasiliy G Tolstov wrote:
In config file some in of this settings exists comment line like
"changes require restart". This is mean exactly restart or reload can do
this?
Run this:
$ psql -c "select name,context from pg_settings"
This will sort out which settings are in which category defini
This is an English language list, Mariano.
The question is
Is it possible to modify the size of pg_xlog? How? Where?
--
Al
2010/6/2 mario martinez hernandez :
> Buenas tardes.
> Mi nombre es Mariano.
> Mi pregunta es.
> ¿ Es posible modificar el tamaño de pg_xlog? ¿como? ¿donde?
> Gracias
> Un
I can't help it.
Lew writes:
> mnavahan wrote:
>>> i [sic] need powerful IDE for it with modernize options (extended editor)
>>> rich
>>> good
>
> Scott Marlowe wrote:
>> Got me. Maybe eclipse has a nice plugin?
>
> YMMV. They might represent overkill for some folks. I enjoy the
> conven
On 3 June 2010 19:17, Kevin Kempter wrote:
> is it possible to specify a default isolation level for a user/role ?
It is. At least for 8.4.
\c test postgres localhost 5432
psql (8.4.2)
You are now connected to database "test" at port "5432" as user "postgres".
postg...@localhost test=#
show def
Hi all;
is it possible to specify a default isolation level for a user/role ?
Thanks in advance...
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
fida aljounaidi wrote:
> For migration purpose (from 8.2 to 8.4)
8.2.what? to 8.4.what?
> (this is my dump command "pg_dump mydb | gzip > /var/dump/db.gz"
Using pg_dump from which version?
> It fails whith this error message:
> pg_dump: la commande SQL a échoué
> pg_dump: Message d'erreu
On Thu, Jun 3, 2010 at 6:01 PM, Vasiliy G Tolstov wrote:
>
> Memory related:
> max_connections
> shared_buffers
> temp_buffers
> max_prepared_transactions
> work_mem
> maintenance_work_mem
> max_stack_depth
> max_files_per_process
> wal_buffers
>
> In config file some in of this settings exists co
Hi
For migration purpose (from 8.2 to 8.4), i'm trying to make a dump of a 16
GB database.
(this is my dump command "pg_dump mydb | gzip > /var/dump/db.gz"
It fails whith this error message:
pg_dump: la commande SQL a échoué
pg_dump: Message d'erreur du serveur : ERREUR: invalid memory alloc req
В Чтв, 03/06/2010 в 17:54 +1000, Shoaib Mir пишет:
> On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov
> wrote:
> Sorry for incorrect question. I mean: does postgresql can be
> reloaded
> without breaking current connections?
> For example:
> I need to incre
On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov wrote:
> Sorry for incorrect question. I mean: does postgresql can be reloaded
> without breaking current connections?
> For example:
> I need to increate some values in postgresql conf file and want to this
> valies applied on running server, can
В Чтв, 03/06/2010 в 14:45 +0700, Anh Ky Huynh пишет:
> On Thu, 03 Jun 2010 10:23:36 +0400
> Vasiliy G Tolstov wrote:
>
> > Hello.
> >
> > I'm use linux and postgresql under xen vps. Vps supports memory
> > balloon (i need to increase memory some time). Can postgresql
> > server has ability to gr
On Thu, 03 Jun 2010 10:23:36 +0400
Vasiliy G Tolstov wrote:
> Hello.
>
> I'm use linux and postgresql under xen vps. Vps supports memory
> balloon (i need to increase memory some time). Can postgresql
> server has ability to graceful reload itself after it configuration
> files changed? Thank Yo
19 matches
Mail list logo
