Hi all.
I need an alternative for running the following command:
"C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start
This way the server starts and logs to C:\yyy\log\pgsql.log.
When I try to register the server as a service though - no logging options are
available an
On Fri, Apr 13, 2012 at 5:08 AM, Wells Oliver wrote:
> I stopped my slave, lowered max_connections to 100 on the primary,
> restarted it, then started the slave back up and it wouldn't go:
>
> 2012-04-12 16:34:32 PDT FATAL: hot standby is not possible because
> max_connections = 100 is a lower s
I stopped my slave, lowered max_connections to 100 on the primary,
restarted it, then started the slave back up and it wouldn't go:
2012-04-12 16:34:32 PDT FATAL: hot standby is not possible because
max_connections = 100 is a lower setting than on the master server (its
value was 200)
Which, OK,
On Mon, Jun 13, 2011 at 10:29 AM, Dinesh Bhandary wrote:
> Hi All -
>
> Is there a way to change work_mem for a session in postgres without
> restarting a database? Please let me know.
In addition the standard set work_mem='512MB'; listed above, you can
make such changes sticky for a user or a da
SET work_mem='1GB'; (or whatever size makes sense)
- Chris
On 06/13/2011 10:29 AM, Dinesh Bhandary wrote:
> Hi All -
>
> Is there a way to change work_mem for a session in postgres without
> restarting a database? Please let me know.
>
> Thanks.
> Dinesh
>
--
Sent via pgsql-admin mailing
rg
Subject: [ADMIN] changing work_mem
Hi All -
Is there a way to change work_mem for a session in postgres without restarting
a database? Please let me know.
Thanks.
Dinesh
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes
to your subscription:
http://www.postgresql.or
Dinesh Bhandary wrote:
> Is there a way to change work_mem for a session in postgres
> without restarting a database? Please let me know.
SET work_mem
http://www.postgresql.org/docs/9.0/interactive/sql-set.html
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To m
Hi All -
Is there a way to change work_mem for a session in postgres without
restarting a database? Please let me know.
Thanks.
Dinesh
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
"Arnold, Sandra" wrote:
> Coming from the Oracle world we were able to have a different
> default tablespace for each user or for a group of users. Can you
> set the default tablespace to be different for a group
> users/schemas in PostgreSQL?
ALTER ROLE xxx SET default_tablespace = yyy;
ht
Coming from the Oracle world we were able to have a different default
tablespace for each user or for a group of users. Can you set the default
tablespace to be different for a group users/schemas in PostgreSQL? Or, do you
have to set the default tablespace at the database level? If you can s
*ukasz Brodziak wrote:
> The version in 8.4. I'm trying to copy the database from Windows
> to Linux. If it is of any importance the version of "Windows
> Postgres" is 8.2
Use pg_dump from your 8.4 machine. I would use the --encoding
switch when I ran pg_dump to get UTF-8 encoding in the dump
gresql.org
> Subject: Re: [ADMIN] Changing locale to 1250
> Are you trying to connect to a PostgreSQL server which runs on
> Windows using a client on Linux, or are you trying to copy the
> database and run your own server on Linux? What database
> version(s), exactly?
>
> -
*ukasz Brodziak wrote:
> I would like to perform some tasks on my linux (ubuntu) using db
> from work unfortunatly the DB has WIN1250 encoding and the
> PostgreSQL in linux has UTF-8 is it possible to somehow change the
> server's locale as I may not change the encoding of the DB.
Are you tryin
Hello,
The question is maybe stupid but it's a trouble to me. I would like to perform
some tasks on my linux (ubuntu) using db from work unfortunatly the DB has
WIN1250 encoding and the PostgreSQL in linux has UTF-8 is it possible to
somehow change the server's locale as I may not change the e
On Thu, Sep 10, 2009 at 7:08 PM, Nicolas Michel wrote:
> Hello,
>
> I made a mistake an got a character set in SQL_ASCII as the defaut encoding
> type :
>
> $ psql -l
> List of databases
> Name | Owner | Encoding
> --+--+---
> cmp_crm | openerp
Hello,
I made a mistake an got a character set in SQL_ASCII as the defaut
encoding type :
$ psql -l
List of databases
Name | Owner | Encoding
--+--+---
cmp_crm | openerp | SQL_ASCII
cmp_crm_demo | openerp | SQL_ASCII
cmp_testcrm | op
Hi Carol
On Tue, Nov 18, 2008 at 4:06 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have some databases that are designated as "SQL_ASCII" encoding. I need
> them to be "UTF-8". I know that "SQL_ASCII" is really the absence of
> encoding. Is there a way to do this?
Try use pg_du
Hello,
I have some databases that are designated as "SQL_ASCII" encoding. I
need them to be "UTF-8". I know that "SQL_ASCII" is really the
absence of encoding. Is there a way to do this?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subs
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
> I have some databases that use SQL ASCII or Latin1 encoding that need
> to be UTF8. When I have drop the database and recreated it with the
> correct encoding I get errors in restoring the data. How is this done?
What is your PostgreSQL version?
For the SQL_ASCII tables it depends what was actually written to the tables.
SQL_ASCII means that the server does not do any conversation and that the
client is responsible for the used encoding. So if there is data in the table
with different encodings (comming from different clients with diffe
I'm at 8.2.3
I do a data only pg_dump. I drop the database, then recreate it with
the correct encoding. Then load the data back in with psql.
Carol
On Jul 15, 2008, at 11:04 AM, Peter Eisentraut wrote:
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
I have some databases that use SQL ASC
Hello,
I have some databases that use SQL ASCII or Latin1 encoding that need
to be UTF8. When I have drop the database and recreated it with the
correct encoding I get errors in restoring the data. How is this done?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
Julius Tuskenis <[EMAIL PROTECTED]> writes:
> b_prekes_br_kodas_pbk_id_seq1 was created automatically creating serial field
> and is in some way connected to it. Thats why I get error saying "...column
> pbk_id requires it." Any way I can't find a way to find and alter this
> dependency.
It's a
Hello Achilleas.
I think you are wrong on this point - I can create some sequence (the
owner is set) and then drop it easily. I think this is because
b_prekes_br_kodas_pbk_id_seq1 was created automatically creating serial field and is in
some way connected to it. Thats why I get error saying
Στις Thursday 03 July 2008 17:19:48 ο/η Julius Tuskenis έγραψε:
> Hello
>
> I noticed, that some serial field is using wrong sequence, so I altered
> the default value pointing to the sequence I want, but now I cant delete
> currently no longer used sequence. Did I do someting wrong changing it?
Hello
I noticed, that some serial field is using wrong sequence, so I altered
the default value pointing to the sequence I want, but now I cant delete
currently no longer used sequence. Did I do someting wrong changing it?
PgSQL 8.1 on Gentoo Linux.
What I try to do
DROP SEQUENCE b_prekes_b
Dear colleagues,
For the last few hours I tried to implement $subj, to no avail. I tried to use
create rule (no grant statement allowed), create function (syntax error on $1),
etc.
I have roles mng and rdr, and want that any newly created class (table, view,
seq, index) will be available for
[EMAIL PROTECTED] (Devrim GUNDUZ) writes:
> Hi,
>
> On Mon, 2006-07-17 at 12:33 +, Richard George wrote:
>> I've run into trouble attempting to change the owner of a particular
>> database. The offending line is -
>>
>> ALTER DATABASE test OWNER TO epg;
>
> There is no way to change ownership
thanks for this- worked a treat!
> Subject: Re: [ADMIN] Changing a database owner on postgres 7.3> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: pgsql-admin@postgresql.org> Date: Mon, 17 Jul 2006 16:26:00 +0300> > Hi,> > On Mon, 2006-07-17 at 12:33 +, Richar
Hi,
On Mon, 2006-07-17 at 12:33 +, Richard George wrote:
> I've run into trouble attempting to change the owner of a particular
> database. The offending line is -
>
> ALTER DATABASE test OWNER TO epg;
There is no way to change ownership of a database with ALTER DATABASE in
7.3.X .
> Can
Hi all,
I'm trying to tweak a schema creation script that works on postgres 8.x so that it will run on postgres 7.3.
I've run into trouble attempting to change the owner of a particular database. The offending line is -
ALTER DATABASE test OWNER TO epg;As I say, this works fine on postgres
Michael Kichanov <[EMAIL PROTECTED]> writes:
> Can i change the encoding of the database with "update pg_database set
> encoding= where datname="
> without any problem with DB integrity?
No. That's not going to magically fix your data to be correct in the
new encoding.
r
Hi All!
Can i change the encoding of the database with "update pg_database set
encoding= where datname="
without any problem with DB integrity?
Thanx in advance!
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> after Tom's last hint I checked the locale of my installation. With a
> test installation with locale C all my problem scripts worked. Now I
> wonder what will happen if I dump my whole database, reinitialize with
> locale C and reload my data. Will th
Hello,
after Tom's last hint I checked the locale of my installation. With a
test installation with locale C all my problem scripts worked. Now I
wonder what will happen if I dump my whole database, reinitialize with
locale C and reload my data. Will this have some impact on my character
data
Hi,
When using redirect_stderr = true the permissions of the resulting
logfile are 600 (owner and group are postgres). Is it possible to change
the permission to 640 or 660 (without recompiling postgres?)?
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-388
Am Sonntag, 31. Juli 2005 14:15 schrieb Martin Nikolov:
> Is there a way to change the database cluster locale initialization?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our l
Is there a way to change the database cluster locale initialization?
I have database cluster initialized with locale set to en_US.iso885915
and I want to change it to en_US.
Becouse en_US.iso885915 is not supported in glibc-2.3.5-i486-4 and I had
to doungrade glibc to 2.3.2 in order to operate w
I just wondered if there is a way to change the variable sign from : to $,
like
\set avar 32
select :avar ; ---> select $avar ;
so I can copy and paste my perl code directly to psql when debugging,
assuming I do a proper \set.
TIA.
Ben Kim
Developer
College of Education
Texas A&M University
Hi,
How do I change the page size in postgresql? I have the postgresql-7.4.3 version.
I am trying to create an r*-tree index on a spatial table with around 100,000 rows. I just want to check if increasing the page size would make the join of two tables faster. Are there any other options I could u
Maybe you already know this but the solution is to create a new
table with varchar(200) copy to it the data from the old one.
Then drop the old one and recreate with varchar(200) then copy
the data back from the tmp table.
Again you probably know all this ,just trying to help...
On Wed, 8 Sep 200
On Wed, 2004-09-08 at 10:45, Warren Little wrote:
> Hello,
> Does pg7.4.x support resizing a varchar column
> ie varchar(30) -> varchar(200)
No, but some folks have done it by hacking the catalogs. not
recommended, make a backup, etc...
> If not does the feature in 8.0 relating to changing colu
Hello,
Does pg7.4.x support resizing a varchar column
ie varchar(30) -> varchar(200)
If not does the feature in 8.0 relating to changing column types support this?
thx
--
Warren Little
Senior Vice President
Secondary Markets and IT Manager
Security Lending Wholesale, LC
www.securitylen
hello
How do i change the definition of a column? one of the columns width is not sufficient to store the data. I want to change the width. how to do that in postgres? I tried doing alter table + change/modify. both of them doesn't work in postgres.
and what is the maximum size to which a postg
As always, there's more than one way to skin a cat...
Create a new table and insert into it:
create newtable (field newdef, field2 newdef);
insert into
newtable (
select oldfield,
oldfield2 from oldtable
);
Create it on the fly with Postgresql casting shortcuts:
select
field1::n
On Wed, Aug 20, 2003 at 11:16:18 -0400,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> Ok. so for now I want to return to where I started. so I renamed the
> table and regenerated my original table with the fields in the order
> that I like. I cannot just do a
> insert into table select * from other_
Title:
Ok. so for now I want to return to where I started. so I renamed the table
and regenerated my original table with the fields in the order that I like.
I cannot just do a
insert into table select * from other_table;
because the fields are in a different or
On Wed, Aug 20, 2003 at 10:49:08 -0400,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> can I now make this field not null?
>
> is it possible to move a field up in a table? now that I have done this
Currently, not without recreating the table. There was some discussion
about that a few months ago, b
Title:
can I now make this field not null?
is it possible to move a field up in a table? now that I have done this move
the new field is at the bottom of the list of fields. From time to time we
have had to make changes to our schema so I will rerun our script
Title:
please ignore last message. I had my columns switched.
sorry about that!
Thanks for the quick response.
jodi
Bruno Wolff III wrote:
On Wed, Aug 20, 2003 at 10:16:38 -0400, Jodi Kanter <[EMAIL PROTECTED]> wrote:
how do I copy from one field to
Title:
ExecUpdate: Fail to add null value in not null attribute study_name
Is there any way around this error. Col1 is a not null field but col2 is
not obviously since it is currently empty!
Thanks for the help.
Jodi
Bruno Wolff III wrote:
On Wed, Aug 20, 20
On Wed, Aug 20, 2003 at 10:16:38 -0400,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> how do I copy from one field to another?
update tablename set newcol = oldcol;
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
htt
Title:
how do I copy from one field to another?
Gaetano Mendola wrote:
"Jodi Kanter" <[EMAIL PROTECTED]> wrote:
I am running 7.3.3. Can I change a field that is varying character(128) to varying character(250)?
nope.You can a) create a new
your case, you'd substitute 254 for 104, your table name for "actor" and
your field name for "actor_full_name";
-Nick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jodi Kanter
Sent: Tuesday, August 19, 2003 1:34 PM
To: Postgres Admin
On Tue, 19 Aug 2003, Jodi Kanter wrote:
> I am running 7.3.3. Can I change a field that is varying character(128)
> to varying character(250)?
You can either add a column, copy the data across and drop the old column
and use rename to give the new column the old name or if you're willing
to hack
"Jodi Kanter" <[EMAIL PROTECTED]> wrote:
> I am running 7.3.3. Can I change a field that is varying character(128)
> to varying character(250)?
nope.
You can
a) create a new column named tmp of character(250).
b) copy the content from old column to new column
c) drop the old column
Title:
I am running 7.3.3. Can I change a field that is varying character(128) to
varying character(250)?
Thanks
Jodi
--
___
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
[EMAI
Thanks very much!!
I had a user who was allowed to create dbs, but wasn't superuser...Now I
just have a superuser.
Benjamin
Devrim GUNDUZ wrote:
Hi,
On Tue, 29 Jul 2003, Benjamin Thelen (CCGIS) wrote:
I would like to change the ownership of a database. The only thing I
could find up to now,
On Tue, 29 Jul 2003 17:41:08 -0400, Tom Lane wrote:
> Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
>> On Tue, 29 Jul 2003, Benjamin Thelen (CCGIS) wrote:
>>> I would like to change the ownership of a database.
>
>> UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE
>> usename='new_
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> On Tue, 29 Jul 2003, Benjamin Thelen (CCGIS) wrote:
>> I would like to change the ownership of a database.
> UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE
> usename='new_owner') WHERE datname='db_name';
That is all you need to do
Hi,
On Tue, 29 Jul 2003, Benjamin Thelen (CCGIS) wrote:
> I would like to change the ownership of a database. The only thing I
> could find up to now, is that it is difficult, but I couldn't find any
> detailed help.
Connect to that database via psql.
Then, first, update pg_database:
UPDAT
hello,
I would like to change the ownership of a database. The only thing I
could find up to now, is that it is difficult, but I couldn't find any
detailed help.
Does anybody know how to do this!?
Probably create a dump, then create a new db, then import all the data?
thanks in advance,
Benja
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> Could somebody tell me the consequences of setting the date forward in time=
> on the server running PostgreSQL and then at a later date, after some tran=
> sactions have been committed, setting the date back in time?
AFAIR, Postgres itself couldn't c
Donald,
It depends on your application and by how much you
change the time.
If you have a database field that is populated with the
system time when you insert records your application
logic may not work as intended.
Not sure why you would want to play with the system
clock in the first place.
Could somebody tell me the consequences
of setting the date forward in time on the server running PostgreSQL
and then at a later date, after some transactions have been
committed, setting the date back in time?
Thanks in advance,
Donald Fraser
On Mon, 10 Sep 2001 01:25:59 + (UTC), Tim Boring <[EMAIL PROTECTED]>:
> Can you change a column modifier after you've created the table? For
> example, I have a table called "authors" with the following columns:
> authorid, authorfirstname, authorlastname, authormi, statecode, country,
> born
ALTER TABLE authors ADD CHECK (NOT authorfirstname = NULL);
Should that be:
ALTER TABLE authors ADD CHECK (NOT authorfirstname IS NULL);
?
Anyway, how about something like the following:
UPDATE pg_attribute SET attnotnull='t' WHERE attname='field_name' AND
attrelid in (SELECT pg_class.oid FROM pg_
It seems that it is not possible to alter column constraints and
table constraints do not include NOT NUL.
But you can use CHECK as workaround:
ALTER TABLE authors ADD CHECK (NOT authorfirstname = NULL);
Arne.
Tim Boring wrote:
>
> Can you change a column modifier after you've created
Can you change a column modifier after you've created the table? For
example, I have a table called "authors" with the following columns:
authorid, authorfirstname, authorlastname, authormi, statecode, country,
born, deceased.
When I created the table, I forgot to make the "authorfirstname" and
Is it possible to change the ownership of a table or database? Can I modify
pg_class and pg_database directly to do this?
--
--
The information contained in this message (including any attachments)
is confidential and intended so
> Is it possible to directly change the type of a column (eg: from int4 to
> date) or does one have to first add a column of the desired type, copy
> the first column's content, then drop this first column ?
No it's not possible. Your solution is correct.
Is it possible to directly change the type of a column (eg: from int4 to
date) or does one have to first add a column of the desired type, copy
the first column's content, then drop this first column ?
On Thu, 6 Apr 2000, Tressens Lionel wrote:
> Is it possible to change the owner of a db after having created it ?
Update the pg_database table in accordance with the user ids listed in
pg_users.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 7526
Hi list,
Is it possible to change the owner of a db after having created it ?
In fact, I have multiple users and I don't want to give them the right to
create dbs. But I have to regularly create dbs for them and make them the
owners of this newly created db.
I found no solution in pgsql docs. C
How can I change the owner of tables in a database?
Chris Bruce
[EMAIL PROTECTED]
Lucent Technologies
2300 Camino Ramon
San Ramon, Ca
925-815-8336
See ALTER USER.
On 2000-02-10, mike focosi mentioned:
> hello all,
>
> i am wondering if it is possible to change the attributes in pg_user and
> pg_shadow for a paticular user. i can't seem to find any documentation on
> 'updating' users other than createuser and dropuser. is it possible to
>
DeBisschop <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 10, 2000 1:53 PM
Subject: Re: [ADMIN] changing privleges in pg_user/shadow
>
> >i am wondering if it is possible to change the attributes in pg_user and
> >pg_shadow
>i am wondering if it is possible to change the attributes in pg_user and
>pg_shadow for a paticular user. i can't seem to find any documentation on
>'updating' users other than createuser and dropuser. is it possible to
>change the users' attributes? for example could this doesn't seem to work:
hello all,
i am wondering if it is possible to change the attributes in pg_user and
pg_shadow for a paticular user. i can't seem to find any documentation on
'updating' users other than createuser and dropuser. is it possible to
change the users' attributes? for example could this doesn't seem to
Wow, Marc is asking for help?
Try: ALTER USER user_name WITH PASSWORD new_password;
Never tried it myself,
-DEJ
> create user allows you to set a password for someone...how to
> you change
> that password after?
>
> update doesn't appear to work...
create user allows you to set a password for someone...how to you change
that password after?
update doesn't appear to work...
Marc G. Fournier
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
81 matches
Mail list logo