2022,182103,182119,182220,182239,182332,182588,182589,182629,182655}'::bigint[]))
-> Seq Scan on wsndata n (cost=0.00..22437445.52 rows=1477767 width=18)
Filter: ((item = 3501) AND ((freq)::text = 'A'::text))
(13 rows)
I am quite perplexed, why is this happening?
postgresql-server version: 9.5.2
Best
Charles
I am running Gutsy (Ubuntu 7.10) and new to Postgresql. I followed the
direction at https://help.ubuntu.com/community/PostgreSQL. I executed
the following commands:
sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -O myuser mydb
[EMAIL PROTECTED]:~$ psql
d!
Thanks.
Charles
---(end of broadcast)---
TIP 6: explain analyze is your friend
grant specific
privileges it has, but allow it to grant all privileges at once, granting
itself as a role?
Now consider this case to illustrate what I mean:
Create a test environment:
charles@admin.localhost=# CREATE ROLE user1 LOGIN PASSWORD 'xxx';
charles@admin.localhost=# CREATE ROLE
st could have a technical solution.
Regards
Charles
>See here:
>
>http://www.postgresql.org/docs/9.4/interactive/sql-createrole.html
>
>In particular the section on INHERIT and in NOTES this:
>
>"The INHERIT attribute is the default for reasons of backwards
>compatibi
r privileges granted directly (apart from connect to
database) to avoid switching between group and user.
Well at least where I am it is getting late and I guess I can use some fresh
air.
Regards
Charles
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow..
values (2,'Text 2');
CREATE FUNCTION test_func()
RETURNS text
LANGUAGE 'plpgsql'
AS $$
BEGIN
RETURN (SELECT what_goes_here FROM test LIMIT 1);
END;
$$;
SELECT * FROM test_func();
test_func
---
Text 1
(1 row)
No need for INTO.
Bye
Charles
On 6/20/2015 17:07, David
not seem to play a role, but the correct
version is as mentioned :=
Bye
Charles
On 6/20/2015 21:37, Bill Moran wrote:
On Sat, 20 Jun 2015 10:44:21 -0700 (MST)
litu16 wrote:
In PostgreSQL I have this table... (there is a primary key in the most left
side "timestamp02" which is no
and return the
modified record.
Now the insert is done as usual using the NEW record returned by the
trigger function.
Bye
Charles
On 6/21/2015 03:07, litu16 wrote:
Hi, thanks
yes I was using AFTER, but it only works with BEFORE
so finally I got it to work.
thanks to all
Im just still wondering
efore" triggers. I would recommend you to read the documentation
on trigger functions. It is excellent and clarifies quite a lot how
things work.
Bye
Charles
On 6/21/2015 16:49, Charles Clavadetscher wrote:
Hi
The two things have nothing in common. With NEW.time_index = t_ix you
set the fi
Hello
I am not sure it is that simple. Probably you need to create operator classes
to be used for indexing.
http://www.postgresql.org/docs/9.4/static/xtypes.html
You are probably better off using the basic data type in your table and using a
composite index.
Bye
Charles
+1
create index on test (((i).id));
ANALYZE
explain select * from test where (i).id = 8909;
QUERY PLAN
-
Index Scan using test_id_idx on test (cost=0.43..8.45 rows=1 width=34)
Index
Hello Urs
I could install PostgreSQL 9.4 on Ubuntu 14.04 without adding repositories
(actually it was an upgrade and I had to move the data manually from 9.3 to
9.4). You may want to try it that way?
Bye
Charles
> -Original Message-
> From: pgsql-general-ow...@postgres
I need to check that when I get home. Suddendly I have the impression that I
may have added a repository to check 9.4 before it was released.
I will get back at that if nobody else can offer a solution, but it may take
some time.
Bye
Charles
> -Original Message-
> From: pgsql-g
that if I hadn't had 9.4
already on the system apt-get would have worked. The error message
suggested that it did not want to replace some existing files (e.g.
libpq if I remember well). I assumed that this was intended to avoid a
working version to be "damaged".
Bye
Charles
Or maybe even better:
http://www.postgresql.org/docs/9.4/static/fuzzystrmatch.html
Search for Levenshtein.
Bye
Charles
On 7/4/2015 11:50, Jimit Amin wrote:
Hello,
I want to compare 2 string and want result like how much percentage or
how much part string is compared. Can I know any option
to install
applications that change settings in pg_hba.conf on my server. Besides
you may consider limiting the trust access to the specific user and
specific database that your application needs to access.
Bye
Charles
On 7/5/2015 12:15, c.bu...@posteo.jp wrote:
I have my own Python applicati
sting how to solve the problem. What I don't know or don't
understand is the following:
- Why is there not a consistent policy violation message when one would
apply as mentioned above?
- Why is the WITH CHECK condition only used on the values in the new record
in the case of an update?
Thank you.
Charles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
continue with some experiments and get back with new
questions if any arise.
PostgreSQL has really a great community ;-)
Enjoy
Charles
> -Original Message-
> From: Stephen Frost [mailto:sfr...@snowman.net]
> Sent: Samstag, 11. Juli 2015 15:22
> To: Charles Clavadetscher
> Cc
eaning.
Maybe it helps.
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dane Foster
Sent: Samstag, 11. Juli 2015 22:56
To: Adrian Klaver
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] A table of magic constants
Hello
Hello
I have a generic question. Where should I/we place suggestions on possible
improvements of the documentation? Is it here or better on pgsql-docs?
Thanks
Charles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Thank you Michael
I will post my suggestions on pgsql-docs to make sure ;-)
Bye
Charles
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Michael Paquier
> Sent: Dienstag, 14. Juli 2015 14:21
&
;boss changed' WHERE name = 'boss';
UPDATE 1
But he can change his own col_privat.
boss=> SELECT * FROM staff;
id | name | boss | col1 | col_privat
+--+--+--+--
2 | joe | boss | 20 | joe privat
3 | sue | boss | 250 | sue changed
1
me to critics it received.
>
> If not: is it unreasonable? why?
IMHO, as I mentioned, this is not an UPSERT use case, but maybe the
implementors of the feature may have different arguments. You could implement
that in a function instead of the application, if you prefer.
Bye
Charles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
indication
"survice unknown" seems to point to an error in the URL and not to an
authorization problem. Maybe some encoding problem?
The irritating thing is that you mention that it works sometimes and
sometimes not. Getting back to the encoding problem idea, is there a
differe
lyze the problem could be to sniff the network traffic and
see what really happens when you make the function call. This could help at
least to discard network problems and may lead to some useful information.
I hope that you will find a solution.
Bye
Charles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
plpgsql VOLATILE;
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Christopher BROWN
Sent: Donnerstag, 27. August 2015 13:50
To: pgsql-general@postgresql.org
Subject: [GENERAL] Strange TRIGGER failure with FOR ... IN ... LOOP
: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles Clavadetscher
Sent: Donnerstag, 27. August 2015 14:57
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Strange TRIGGER failure with FOR ... IN ... LOOP ...
INSERT
Hello
You declare your
ERAL] Strange TRIGGER failure with FOR ... IN ... LOOP ...
> INSERT
>
> On 08/27/2015 06:33 AM, Christopher BROWN wrote:
> > Hello Adrian,
> >
> > Yep, Charles' explanation helped me understand what was going on.
> > Before that, I was as confused as you were (i
um or mailing list.
- If you have produced a SQL file dumping your whole clusterv (pg_dumpall),
then you should only need to reinstall PostgreSQL and run the file as a script
(from command line or psql). There is no upload of sql file, unless I don't
understand what you mean.
Bye
Charles
F
Well the rest should be easy.
psql -U ... -h ... -p ... -d ... -f sql_file.sql
http://www.postgresql.org/docs/9.4/static/app-psql.html option "f"
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson
Sent: Sonntag, 30. August 2015 16:2
://www.postgresql.org/docs/9.4/interactive/client-authentication.html
A tool I heard about, but never used is phpPgAdmin. You may want to take a
look: http://phppgadmin.sourceforge.net/doku.php
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On
-j4 -s all && make install"
then init the db and set everything with config, ssl certs, and cluster
creation and joining.
Any help on this would be really appreciated.
Thanks guys
Charles
Hello
Not sure I get it right, but all three fields are not nullable. So they will
always have a value, which is what I understand of "are specified".
What do you need the trigger for in that case?
Bye
Charles
> -Original Message-
> From: pgsql-general-ow..
elp:
kofadmin@kofdb.localhost=> SET datestyle TO 'ISO';
SET
kofadmin@kofdb.localhost=> select now();
now
2015-09-22 12:53:38.123+02
(1 row)
If you want the change to be persistent you can use:
ALTER DATABASE database_name SET datestyle TO &#
2.09.2015 15:53:50.44 CEST
db=> SET datestyle TO "ISO";
SET
db=> \copy testdate to testdate.csv csv header ;
COPY 3
Content of file:
timedate
2015-09-22 15:53:48.268+02
2015-09-22 15:53:49.612+02
2015-09-22 15:53:50.44+02
So it is actually a matter of instructing the client to
> aklaver@test=> create table pr_test(x int, y int);
>
> aklaver@test=> select * from pr_test where (x, y) between (1, 3) and
> (3,2) order by x,y;
> x | y
> ---+---
> 1 | 3
> 1 | 4
> 2 | 1
> 2 | 2
> 2 | 3
> 2 | 4
> 3 | 1
> 3 | 2
+1, nice.
--
Sent via pgsql-general mailing
Hi
What error do you get?
- Permission denied or table does not exist? Latter would indicate a
problem with the search_path and you should fully qualify the table name
in the function body.
- Did you create the function as postgres user?
Bye
Charles
On 30/10/2015 07:56, rajan wrote:
Yes
this is not the case.
Bye
Charles
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Raymond O'Donnell
> Sent: Samstag, 31. Oktober 2015 12:42
> To: David Blomstrom ; pgsql-general@postgres
a good start:
https://www.postgresql.org/docs/9.5/static/overview.html
Regards,
Charles
Regards,
SSR
--
Charles Clavadetscher
Swiss PostgreSQL Users Group
http://www.swisspug.org
http://www.pg
the bulk update from a record field, e.g. a
timestamp or something like this, you may use WHEN to exclude them from firing
the trigger. I am not sure if it is possible to use a condition other than
using the fields of the old or new record.
https://www.postgresql.org/docs/current/static
Yes. I was advised of that. Sorry for the mistake.
Charles Weitzer
Senior Recruiter
The Voleon Group
char...@voleon.com
Office: 510.704.9870 x 7012
Mobile: (510) 558-9182
www.voleon.com
Confidential: This e-mail may contain confidential and/or privileged
information. If you are not the
data with their version in postgres database table.
You can start reading here for the current version (9.5 at the time of this
writing):
https://www.postgresql.org/docs/current/static/datatype-xml.html
https://www.postgresql.org/docs/current/static/functions-xml.html
Regards
Charles
--
erts {} values back to [] without treat
> it as a string and use replace, what I think that is
not the ideal solution because it may can't satisfy more complex arrays.
Would it help to simply cast the argument to TEXT[]?
select function_x(1,55,(new.situations)::TEXT[]);
I am not sure
ll Stack ---
PL/pgSQL function inner_func() line 5 at GET DIAGNOSTICS
PL/pgSQL function outer_func() line 3 at RETURN
CONTEXT: PL/pgSQL function outer_func() line 3 at RETURN
outer_func
1
(1 row)
Regards
Charles
--
Swiss PostgreS
ble.
This may help you?
http://laurenz.github.io/pgreplay/
Regards
Charles
>
> When I log, I see this kind of queries :
> "duration: 0.046 ms parse : UPDATE user SET money = money + $1
> WHERE id = $2"
>
> But I would like to have only : "UPDATE u
| true
admin| true
accounts | true
contacts | true
(5 rows)
or
select key, (value::json)->'status' from jsonb_each(
'{
"accounts": {"status": true},
"admin":{"status": true},
"calendar": {"status": false},
"ch
d to database "kofdb" as user "kofadmin".
kofadmin@kofdb.localhost=> select lower('И'); <-- This works on a DB with
another collation and ctype
lower
---
и
(1 row)
It seems to be a problem with collation and or ctype.
What are the settings of the
Hello
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles
> Clavadetscher
> Sent: Montag, 8. August 2016 09:30
> To: 'Alexander Farber' ; 'pgsql-general'
>
> Subje
llate "en_US")) ;
lower
---
и
(1 row)
Maybe other more expert than me on this topic will suggest better solution.
Bye
Charles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.3 on Windows, but works
> on Mac, Linux
>
> Hello Charles, unfortunately on Windows 7 this fails:
>
> psql (9.5.3)
> Type "help" for help.
>
> # select lower(('И'::text collate "en_US")) ;
> ERROR: collation "en_US" for enc
>
>
> How to resolve this "naming conflict" best or maybe there is some better way
> like using some "internal" table
> implicitly created by the type declaration?
>
>
> Thank you
>
> Alex
>
>
> P.S. Below is my full source code and the full log ou
: password authentication failed
for user "rshepard"
Does the user rshepard exist in the new 9.5 instance?
What was the error message?
As above.
Thanks,
Rich
--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenstrasse 18
CH – 8005 Zü
ion failed for user "rshepard"
Well, there you have it. As Adrian suggested you may set temporarily the
authentication method to trust, set yourself a password and change it
back to md5.
That should do.
Bye
Charles
The crm database is owned by me.
I have never used it, but I am
already answered that. You can set the connection authentication
method to trust. This can have some risks, however.
Bye
Charles
Thanks again,
Rich
--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenst
Hi
On 09/04/2016 05:16 PM, Charles Clavadetscher wrote:
Hi
On 09/04/2016 05:14 PM, Rich Shepard wrote:
On Sat, 3 Sep 2016, Adrian Klaver wrote:
Or if you are fine running the 9.5 instance at port 5432, what happens
if you do?:
psql -d postgres -U some_user -p 5432
$ psql -d postgres -U
T PRIVILEGES
command.
"
As I think we can't mix the rights (Main_Admin = US_A + US_B + US_C...).
Actually you could:
GRANT us_a, us_b, us_c TO main_admin;
Now, if you have time for it, I would suggest that you take it to read
about the roles and privileges system in Postg
Hello
On 09/05/2016 05:56 PM, Charles Clavadetscher wrote:
Hello
On 09/05/2016 04:19 PM, Adrian Klaver wrote:
On 09/05/2016 05:45 AM, Durumdara wrote:
Dear PG-masters!
We want to put more databases to one server, to "public" schema:
DB_A, DB_B, DB_C.
The PUBLIC schema is contai
e GROUP BY clause or be used in an aggregate function|
> Where: PL/pgSQL function words_skip_game(integer,integer) line 27 at SQL
> statement
You must group by played, as the message suggests. You are implicitly selecting
the column through order by, although you don't have it
Hello
On 09/07/2016 03:24 PM, Durumdara wrote:
Dear Everybody!
I read the documentation based on your example. First reactions.
2016-09-05 18:25 GMT+02:00 Charles Clavadetscher
mailto:clavadetsc...@swisspug.org>>:
GRANT us_a, us_b, us_c TO main_admin;
Ah, it's good.
Hello
I did oversee the additional questions...
On 09/07/2016 06:45 PM, Charles Clavadetscher wrote:
Hello
On 09/07/2016 03:24 PM, Durumdara wrote:
Dear Everybody!
I read the documentation based on your example. First reactions.
2016-09-05 18:25 GMT+02:00 Charles Clavadetscher
Hello
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Durumdara
Sent: Mittwoch, 14. September 2016 17:13
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restricted access on DataBases
Dear Adrian and Charles!
I tried to create
Firstname
Lastname\r\\rEMAIL;TYPE=INTERNET;TYPE=OTHER:email\r\\rEND:VCARD
(1 row)
Does anybody have an idea what I am doing wrong?
Thank you for your help.
Charles
--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenstrasse 18
CH – 8005 Zürich
http://www.swisspug.org
+-
Hi Rob
On 09/25/2016 01:39 PM, rob stone wrote:
>
> On Sun, 2016-09-25 at 10:29 +0200, Charles Clavadetscher wrote:
>> Hello
>>
>> I am using PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by
>> gcc
>> (Debian 4.7.2-5) 4.7.2, 64-bit
>>
&g
Hello Tom and Adrian
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
> Sent: Sonntag, 25. September 2016 18:38
> To: Tom Lane ; Charles Clavadetscher
>
> Cc: pgsql-general@pos
alter default privileges
statement. In the second it works if you create a table as user u_tr_main.
> ---
>
>
> db_testrole-# \ddp
> Default access privileges
> Owner | Schema | Type | Access privileges
> ---++
some.rows.sh
I may be overseeing something, but what about dependencies between
tables, sequencies, indexes, etc.? I guess that if one takes the first
100 rows of a table referenced by another table, there is no guarantee
that in the first 100 rows of the referencing table there will not be
s
key contraint on table2 using
id and phone_id.
CREATE UNIQUE INDEX table2_pkey ON table2 (id, phone_id);
ALTER TABLE table2 ADD PRIMARY KEY USING INDEX table2_pkey;
After that you should be able to add the foreign key to table1.
Hope this helps.
Charles
> Could you please share the details o
Hello Yogesh
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yogesh Sharma
> Sent: Mittwoch, 16. November 2016 07:59
> To: Charles Clavadetscher ;
> pgsql-general@postgresql.org
> Subject:
ull
roll_number | character varying(20) | not null
Indexes:
"table1_pkey" PRIMARY KEY, btree (id, roll_number)
Foreign-key constraints:
"fk_key" FOREIGN KEY (id, roll_number) REFERENCES table2(id, roll_number)
ON UPDATE RESTRICT ON DELETE RESTRICT
Regards
Charles
>
Rethinking that
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles
> Clavadetscher
> Sent: Donnerstag, 17. November 2016 09:12
> To: 'Yogesh Sharma' ; 'John R Pierce'
using the database, but is the only one where we expect such peaks).
So I'd be very grateful for advice on this subject.
Thank you.
Regards
Charles
--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenstrasse 18
CH – 8005 Zürich
http://w
Hello Kevin
Thank you very much for your input. I appreciate it very much.
> -Original Message-
> From: Kevin Grittner [mailto:kgri...@gmail.com]
> Sent: Dienstag, 22. November 2016 22:37
> To: Charles Clavadetscher
> Cc: pgsql-general@postgresql.org
> Sub
t
> dropping various PostGIS (and other) tables and functions. Additionally,
> while I doubt the students would do
> something like drop a public function or supporting table (like
> spatial_ref_sys), it nonetheless seems like a poor
> idea for these database objects to be vuln
fact we have
integrated this feature to extract comments to generate the DB documentation in
our internal MediaWiki based wiki.
If you are interested in more details on that, including additional reasons why
it is a good idea to use "comments on" instead of comments in the source co
Hello
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Durumdara
Sent: Donnerstag, 8. Dezember 2016 10:13
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Who dropped a role?
Hello!
Sorry, meanwhile I found it as Group Role.
I ne
Hello Kevin
Getting back at this.
> -Original Message-
> From: Kevin Grittner [mailto:kgri...@gmail.com]
> Sent: Mittwoch, 23. November 2016 17:04
> To: Charles Clavadetscher
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] max_connections limit violat
ame | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---++-+--+-+---+-+-+---+---
test_id_seq | 1 |
)
> VALUES (1, 'foo', 1), (2, 'bar', 1), (3, 'baz', 3);
>
> GRANT SELECT ON accounts TO PUBLIC;
>
> ALTER TABLE accounts ENABLE ROW LEVEL SECURITY;
>
> CREATE POLICY account_ownership ON accounts FOR SELECT
> USING (owner_id = (SELECT id FROM accoun
Hello Simon
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Simon Charette
> Sent: Freitag, 16. Dezember 2016 07:02
> To: Charles Clavadetscher
> Cc: pgsql-general@postgresql.org
>
Hello again
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles
> Clavadetscher
> Sent: Freitag, 16. Dezember 2016 07:41
> To: 'Simon Charette'
> Cc: pgsql-general@postgre
1 | 25 | 270 | Arup
> (10 rows)
>
>
> Say, I know the id 6 where content is "Arup". Now from this row, I want to
> delete all next rows where the content is
> "Arup". How should I achieve this?
Assuming that "next" means id > 6:
ion/?utm_source=PoD&utm_medium=referral&utm_campaign=1783980583>
&utm_medium=referral&utm_campaign=1783980583
Regards
Charles
Seems like a thing that should exist. I can find a variety of blog posts,
mostly about Oracle and MS SQL Server, but nothing that appears part
gs:
SELECT * FROM pg_size_pretty((100.0*(2^20)*10.0)::BIGINT);
-[ RECORD 1 ]--+
pg_size_pretty | 9766 GB
This could explain the errors you get from the server. You may be trying to use
much more memory than you have.
Regards
Charles
> [postgresql.conf]
> max_connect
Forwarding to list.
-Original Message-
From: ajmcello [mailto:ajmcell...@gmail.com]
Sent: Freitag, 30. Dezember 2016 07:05
To: Charles Clavadetscher
Subject: Re: [GENERAL] performance tuning postgresql 9.5.5.10 [enterprisedb]
There are no connections except one cli when running the
|
>
> Indexes:
> "webtraffic_archive_day_2016_04_15_action_wbidx" btree (action)
> "webtraffic_archive_day_2016_04_15_domain_wbidx" btree (domain)
> "webtraffic_archive_day_2016_04_15_profile_wbidx" btree (profile) CLUSTER
>
tore again (steps 5-7).
You may also try to omit step 6 but then all you DB objects will be owned by
postgres. If this is what you need it is fine.
Hope this helps.
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alex
Instead of creating a superuser you may simply grant the privilege on the
database:
CREATE ROLE alex LOGIN PASSWORD '...';
GRANT CREATE ON DATABASE icare TO alex;
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf
Hello
Why don’t you simply change the port in postgresql.conf and restart the server?
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll
Sent: Mittwoch, 23. Dezember 2015 09:58
To: pgsql-general
Subject
with plain pg_dump.
>
>pg_dump -h localhost -p 5432 -Fc > dump.sql
>
>pg_restore -h localhost -p 5532 dump.sql
>
>I tried this, but nothing appears to happen when entering the commands.
>Attached is a screenshot of the shell window - what am I doing wrong?
This should
From: Killian Driscoll [mailto:killiandrisc...@gmail.com]
Sent: Mittwoch, 23. Dezember 2015 11:02
To: Charles Clavadetscher
Cc: Andreas Kretschmer ; pgsql-general
Subject: Re: [GENERAL] Transfer db from one port to another
On 23 December 2015 at 10:58, Charles Clavadetscher
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll
Sent: Mittwoch, 23. Dezember 2015 11:19
To: John R Pierce
Cc: pgsql-general
Subject: Re: [GENERAL] Transfer db from one port to another
On 23 December 2015 at 11:07, John R Pier
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll
Sent: Mittwoch, 23. Dezember 2015 11:26
To: John R Pierce
Cc: pgsql-general
Subject: Re: [GENERAL] Transfer db from one port to another
On 23 December 2015 at 11:19, Killian
We had that already upthread.
Did you set the path to the bin dir of PostgreSQL as of previous posts?
Regards
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll
Sent: Mittwoch, 23. Dezember 2015 15:14
To: Adrian
> \set testvar 'sum(id) from test'
db => select :testvar;
sum
-
55
(1 row)
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Edson F. Lidorio
Sent: Freitag, 25. Dezember 2015 14:23
To: pgsql-general@
g_text,_xml_content_into_a_field
Bye
Charles
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston
Sent: Freitag, 1. Januar 2016 19:02
To: ERR ORR
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How do I implement a .XSD in Postgres?
alues
returned that you need.
Bye
Charles
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sachin Srivastava
> Sent: Freitag, 8. Januar 2016 08:24
> To: pgsql-general@postgresql.org
> Subject: [
Hello
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Saulo Merlo
> Sent: Montag, 11. Januar 2016 08:12
> To: Vitaly Burovoy
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Slow Query - PostgreSQL 9.2
Hello
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sachin Srivastava
> Sent: Dienstag, 12. Januar 2016 08:40
> To: pgsql-general@postgresql.org >> PG-General Mailing List
>
> Subject: [GENERAL] Giving error fo
m which it must apply.
Bye
Charles
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Christophe Pettus
> Sent: Montag, 25. Januar 2016 05:18
> To: Postgres General
> Subject: Re: [GENERAL] ERROR: c
1 - 100 of 234 matches
Mail list logo
